How to connect to the the Public Holidays Azure Open Dataset

[bdarbo78]

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.

[v-rongtiep-msft · Accepted solution]

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. 

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]

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]

@bdarbo78 , there is something similar discussed here, check if that can help 

https://radacad.com/create-a-date-dimension-in-power-bi-in-4-steps-step-3-public-holidays

[bdarbo78]

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.