Sunday, December 2, 2018

How do you bring in XML data into PowerBI?

Here is how to do it.

Launch PowerBI. Click Get Data.

Click XML. Open dialog is displayed. Previously I saved a CD.XML file from W3C site here.



I highlight CD.xml and click Open. Power BI processes my input, and brings up the CD.xml in the Navigator as shown.


I place a check mark for CD.XML. The file loads into the Navigator.


I click Load. My action Load gets processed.


Now CD.XML is loaded into PowerBI. I still don't see it.


 Change it to DataView on the Left. Now you see the data in CD.xml.


That's all folks. Now you can do what you want to do in PowerBI.

No comments: