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
Anonymous's avatar
Anonymous
Not applicable
8 years ago

HaraldHBub,

Could you please upload the xml file to OneDrive and post shared link of the file here? The above XML file you post contains emoji.

Regards,
Lydia

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