Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 on a dashboard.
Is there a simple way to make this work?
The xml data looks something like this (and resides as text in one of the columns):
@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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.