Forum Discussion

New Member

2 years ago

Solved

Parsing XML element values in Power Query

I need to parse some XML with data stored in element values (rather than attributes) in Power Query. This works fine as long as the elements don't have sub-elements as follows: <people> <person...

Need Help

BA_Pete
2 years ago
Hi sc20d2 ,

Open your query in Advanced Editor then adjust the Source step to change Xml.Tables to Xml.Document.

You'll still need to do a bit of jiggery-pokery to get the data into the shape you need, but this will at least expose all the data elements for use.

Pete