Forum Discussion
Analitika
Post Prodigy
Post ProdigyLoad XML in Power BI
Hi,
I would like to ask how to properly parse xml in Power BI. It looks like this:
Need somehow to parse. I know how parse but structure becomes messy.
2 Replies
v-zhangtiCommunity Support
Hi, Analitika
In Power Query, you can parse the contents of a column with text strings by identifying the contents as either a JSON or XML text string.
Parse text as JSON or XML - Power Query | Microsoft Learn
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Analitika
Do I need select all columns to make active parse button?
