Which three actions should you perform in sequence?

DRAG DROP

You are building a dataset from a JSON file that contains an array of documents.

You need to import attributes as columns from all the documents in the JSON file. The solution must ensure that date attributes can be used as date hierarchies in Microsoft Power BI reports.

Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

View Answer

Answer:

Explanation:

1- Convert list to table

2- Expand Column

3- Set Date type

Here is an example: https://youtu.be/B4kzyxnhQfI

The definition of the function which expand columns: https://docs.microsoft.com/en-us/powerquery-m/table-expandrecordcolumn