I'm trying to create a report using power bi using sql server data and some of the columns documnts converted to xml and in my report I want to reconvert into text and show the data. Can you please help me with this.
Thanks in Advance
Go to Solution.
Hi @RajaEssaki ,
You can try to use “Parse to xml” in the query editor.
You can refer to this case:https://community.powerbi.com/t5/Desktop/XML-document-data-in-a-column/td-p/448699
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
We spoke with Power BI Super User, Greg Deckler, about his charity work
Continue your learning in our online communities.