Only reading part of an XML file

[Magnus70]

Hi!

I'm trying to get data from an XML file but Power BI only reads the first tags in the file.

Something wrong in the XML file or?

[amitchandak · Accepted solution]

@Magnus70 , Open power query and check does it show a expand sign , opposite side arrows in any of the steps. check, are they expanded or not ?

How to import JSON Data: https://youtu.be/MPYfEetvFH4

[Magnus70]

Thanks @amitchandak ! 🙂

I saw that I needed to expand certain columns and I think I also need to create separate tables för order head and order rows. They seem to be in one table right now in the XML file as you showed in the video.

Best regards

Magnus