Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to Solution.
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
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 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
Hi @Anonymous ,
It seems the package has some issue in the latest version of Desktop. It can't work even in the official demo. When the issue is fixed, we could retrieve the data using the URL like below. Please refer to the snapshot below.
Best Regards,
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
84 | |
65 | |
62 | |
55 |
User | Count |
---|---|
172 | |
108 | |
105 | |
71 | |
70 |