Forum Discussion

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

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

Frequent Visitor

8 years ago

Strange.

See if this works

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
  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
  - Anonymous
    Not applicable
    8 years ago
    HaraldHBub,
    
    I am not sure that how Excel parse the above result, and I haven't found solutions to get same result after importing XML file in Power BI Desktop.
    
    In your scenario, I would recommend you save the xml file as .xlsx file after you open it in Excel, then directly connect to the Excel file in Power BI Desktop.
    
    Regards,
    Lydia