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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
bdarbo78
Frequent Visitor

How to connect to the the Public Holidays Azure Open Dataset

I am struggling to find documentation or a step-by-step guide for importing data from the Public Holidays Azure Open Dataset, 

either to a Power BI model or to a dataflow. 
I cannot make sense of what is described in the dataset documentation.

I would appreciate any help: which connector to use, url to use ...Etc.

1 ACCEPTED SOLUTION
v-rongtiep-msft
Community Support
Community Support

Hi @bdarbo78 ,

 You can connect using PBI's Web connector on the Power BI Desktop.Then edit the data in the Power Query. If you want to see the data on the service, you can also publish to Service. 

vpollymsft_0-1652147142977.png

Publish to web is free, but anyone on the Internet will be able to access the report and the data it contains.

More details: publish to web 

 

I have also found a similar post, please refer to it to see if it helps you.

Need help connecting PBI to public government data 

 

If I have misunderstood your meaing , please provide more details.

 

Best Regards

Community Support Team _ Polly

 

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

 

View solution in original post

4 REPLIES 4
v-rongtiep-msft
Community Support
Community Support

Hi @bdarbo78 ,

 You can connect using PBI's Web connector on the Power BI Desktop.Then edit the data in the Power Query. If you want to see the data on the service, you can also publish to Service. 

vpollymsft_0-1652147142977.png

Publish to web is free, but anyone on the Internet will be able to access the report and the data it contains.

More details: publish to web 

 

I have also found a similar post, please refer to it to see if it helps you.

Need help connecting PBI to public government data 

 

If I have misunderstood your meaing , please provide more details.

 

Best Regards

Community Support Team _ Polly

 

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

 

bdarbo78
Frequent Visitor

Thanks for the link. However, the service seems no longer to be free. 
In addition, there are other interesting Azure Open Datasets and I am still curious to learn how to connect to them from Power BI. 

amitchandak
Super User
Super User

Thanks for the link. However, the service seems no longer to be free. 
In addition, there are other interesting Azure Open Datasets and I am still curious to learn how to connect to them from Power BI. 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.