Forum Discussion
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 ...
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
Anonymous
Yeah, that is the workaround I had to use, but it does give some issues with doing several exports and automating the import though. However thank you for trying :)
Regards