World Holidays List

[Anonymous]

Hi Community, 

I am working on a requirement which needs the weekends & holidays out of the equation. The issue here is the dataset caters to a lot of countries which means handling holidays, belonging to different geographies.

I have came across Azure dataset as below, not sure how to connect to the notebook.

https://azure.microsoft.com/en-us/services/open-datasets/catalog/public-holidays/

I am looking out for a dataset that has all data included. If not, any suggestions what should be the best way to handle this.

Has anyone dealt with such a scenario?

[v-shex-msft]

Hi @Anonymous,

You can try to export them to standalone files and use power bi to getting data or try to find out the source rest api url and use a web connection to get data.

For the first method, it needs to manually manage and update the exported file to refresh. For the second one, its records can be refreshed when you click on the refresh button on power bi side.
Regards,

Xiaoxin Sheng

[lbendlin]

Where do you want to consume that data? in a regular Power BI dataset or in Azure Synaptics?

You can always recreate the data from the original sources (PyPI and Wikipedia).