Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to 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.
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.
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.
@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
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.
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |