Forum Discussion
Extract values from xml in column
slarsson,
I import the above xml data into Power BI Desktop, and get the following column.
After I drill down column step by step, I get the following table eventually, does it return your expected data?
Regards,
Lydia
Perhaps a better way to explain the issue:
I have a Sharepoint Online data source names 'Signals'. One of the columns in this sharepoint is called Evidence XML, and contains XML data (the XML provided above), which was generated from a Nintex repeating section form. So In the case of the example there are two sets of data in the repeating section. I want to be able to to visually display this data in the report, in such a way that when I filter on the one Signal, the two corresponding Evidence piece described in the EvidenceXML field display as a table/list/whatever-makes-most-sense.
Hopefully that is clear enough. Again, new to this, so probalby not explaining it well and probably missing some basic steps.
Thanks in a advance for any help.