Data package using Power Query in Power BI

Hi Anonymous,

We've done a bug fix release this morning which includes a fix for an issue that would have affected your use of the mentioned data packages. We've also provided a workaround for a known bug which we are working with the Power BI support team to resolve.

Please follow the setup steps to get the latest versions of the functions into a Power BI file. Once this has been done, you can use the following Power Query expressions to create two new queries: one for the Air Quality data package and another for the Pharmaceutical Drug Spending by countries data package:

A query that returns data from the 'monthly-averages' resource/data file in the Air Quality data package:

let
    data = DataPackageTable("https://datahub.io/core/london-air-quality", null, "monthly-averages")
in
    data

A query that returns data from the 'data' resource/data file in the Pharmaceutical Drug Spending by countries data package:

let
    data = DataPackageTable("https://datahub.io/core/pharmaceutical-drug-spending", null, "data")
in
    data

Hope this helps.

Michael