Utilising Get Data from an MS Access database in Power BI.

One of the neat things about Power BI is the large number of connectors to Get & Transform data. We’ve been working with flat files until now but to realise the full potential of Power BI, we’re going to start having to work with REAL data.

We’re taking a break from the Power BI JSON series to have a quick overview of some of the tools in Power BI that you might have overlooked in your rush to create dashboards and reports. Here are some of the features we think that are worth a special mention:

Last week we created a data set that hat the lottery combinations by date. What if we wanted to know when they were last drawn?

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.