Using the Power Query editor to determine unique combinations from the NY Powerball data.

Welcome back to Power BI Tips! This week, we begin Just Speculating Over the NY Powerball numbers.

Last week we finished creating our queries and got our Powerball data together. Let’s have a look at the field pane to see what tables are available to use.

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.