Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Anonymous
Not applicable

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

1 ACCEPTED 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

View solution in original post

4 REPLIES 4
v-jiascu-msft
Employee
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,

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

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.

Data-package-using-Power-Query-in-Power-BI

 

 

Best Regards,

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.