Forum Discussion
World Bank Open Data with Power BI?
Hello,
Is it possible to consume World Bank Open Data with Power BI without having to write custom connectors?
World Bank Open data is available as XML and JSON.
Examples are here:
https://datahelpdesk.worldbank.org/knowledgebase/articles/898581-api-basic-call-structures
I could not find any examples for Power BI connecting and making use of World Bank Open Data.
Any guidance is much appreciated.
Thanks
Anonymous ,if data is available as JSON/XML you can import as that and work on it. You need to expand the various levels and create a model around it?
https://www.youtube.com/watch?v=ipI6mrWLQKA
https://www.youtube.com/watch?v=6A55DmIHqBY
XML -https://www.youtube.com/watch?v=uH-4BpjMWUY
Please provide your feedback comments and advice for new videos
Tutorial Series Dax Vs SQL Direct Query PBI Tips
Appreciate your Kudos.
2 Replies
- amitchandak
Super User
Anonymous ,if data is available as JSON/XML you can import as that and work on it. You need to expand the various levels and create a model around it?
https://www.youtube.com/watch?v=ipI6mrWLQKA
https://www.youtube.com/watch?v=6A55DmIHqBY
XML -https://www.youtube.com/watch?v=uH-4BpjMWUY
Please provide your feedback comments and advice for new videos
Tutorial Series Dax Vs SQL Direct Query PBI Tips
Appreciate your Kudos.Thanks amitchandak for the links.
Yes, I need to expand and create a model in Power BI