Forum Discussion
Extract values from xml in column
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.
did you manage to find the solution to this? Having the same issue