Load XML in Power BI

[Analitika]

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.

[v-zhangti]

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?