World Bank Open Data with Power BI?

[Anonymous]

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

[amitchandak · Accepted solution]

@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.

[Anonymous]

Thanks @amitchandak  for the links.

Yes, I need to expand and create a model in Power BI