Forum Discussion
Handling of spaces when importing XML data
I'm using several sample XML files from an external system to test my report. This has been going well so far, but now two things cause problems. In one of the files I find an element with just white...
v-yalanwu-msft
Community Support
Community SupportHi, AlexHeinze ;
You can check if these related post can is useful to you.
Import Data from XML Using Power Query | MyExcelOnline
A Primer on JSON and XML Files in Power BI (iterationinsights.com)
Power Query XML connector - Power Query | Microsoft Learn
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Yalan, I did check these (and lots of others), but unfortunately they don't explain the handling of leading and trailing blanks in the XML.