Last week, we successfully extracted the names of the columns from the metadata of the JSON file. Now it’s time to put the two queries together!

Remember last week we brought in our JSON file and focused on transforming and preparing the dataset portion. This time, we’re going to retrieve the column names from the metadata.

Power BI exercise focusing on JSON files using the NY Powerball data.

Power BI exercise focusing on JSON files using the NY Powerball data.

Using a multi-row card visualisation to display the USD exchange rate from the RBA RSS feed

Using the Power Query Editor to parse through the Reserve Bank of Australia's RSS feed in XML format.

This week we start a new project on using Get Data with the XML format.

Last week using the US Historical Population Estimates we created our first DAX formula. Now we have categorised our data by decade, how can we focus the view on a specific decade?

The fourth part in our series involving the US Historical Population Estimates data set. Using DAX to create a calculated column.

The third part in our series involving the US Historical Population Estimates data set. Creating a basic line chart visualisation with the data in Power BI.