Forum Discussion
Extract values from xml in column
I've found all sorts of posts that are similar, but nothing seems to work for me. I have a column that contains xml data. I need to extract that table data into something usable so I can display it...
If I save the xml as a file and add it as a data source, then yes i can eventually drill down to the right level. The problem is the xml is stored in a text field, so I can't get it to recognize it. Even when I use the xml file i can only drill down to the right level of data in the Data screen - not in the Report screen.
The xml comes from a repeating section in a Nintex Form I built in Sharepoint. XML is the only way I can access that info, so I was able to get it displayed in a column in Sharepoint. I'm definitley very new to PowerBI, so not really sure how else to get to the data. Utlimately I just want to be able to show all the data in the XML somehow on a report/dashboard.
Hi slarsson
Did you find the solution ??