Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Data package using Power Query in Power BI

Let me know the use of data package . Also the code for the data package using Power Query(Advanced editor) in Power BI in which the data is .json/.csv format (prefered Frictionless data).

#DataPackageHelper #DataPackageTable #DataPackageTables

General Comment
Need Help
Show and Tell
Tutorial Requests
  • michaelamadi's avatar
    michaelamadi
    7 years ago

    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

4 Replies