Forum Discussion
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
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 dataA 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 dataHope this helps.
Michael
4 Replies
v-jiascu-msftMicrosoft Employee
Hi Anonymous ,
Could you please make it more clear what the Data Package it is? I suppose you mean the service-dataflows-overview. So what kind of code would you like?
Best Regards,
Refer this: https://github.com/nimblelearn/datapackage-m
In this video, the data is uploaded of gdp, i want to upload other data (eg air-quality) from https://datahub.io/core/london-air-quality or other data like https://datahub.io/core/pharmaceutical-drug-spending which itz giving error.
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 dataA 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 dataHope this helps.
Michael