Forum Discussion

HaraldHBub's avatar
HaraldHBub
Frequent Visitor
8 years ago

Importing XML gives all data in single column

Hi,   I'm attempting to import data from an XML file we get exported from one of our systems. I have little experience with XML, so the error might be obvious. Excel opens it just fine and returns ...
Need Help
HaraldHBub's avatar
HaraldHBub
Frequent Visitor
8 years ago

One Drive link to XML

 

There you go. This is a dummy XML as the other contains sensitive information. This is exported from the same system and should contain the same structure, just a much smaller dataset.

 

When I try to import and expand all my data comes in the Row query, Cell.Data.Element:Text column

 

Thank you!

 

Regards

Harald

Anonymous's avatar
Anonymous
Not applicable
8 years ago

HaraldHBub,

I am unable to access the XML file, please share it in OneDrive and post shared link of it so that I can download the file from my side.

Regards,
Lydia

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      HaraldHBub,

      I get the following result when using Data->From Other Sources->From XML Data Import option in Excel. When I using Data->New Query-> From file-> From XML option Excel  to import the data, I get same result as that in Power BI Desktop.



      Regards,
      Lydia

      • HaraldHBub's avatar
        HaraldHBub
        Frequent Visitor
        8 years ago

        I get the same result as you using the data -> from other sources -> XML option, but i get the following result using the file -> open option, which is possible to work with and what i was hoping to get to in Power BI