Forum Discussion

Analitika's avatar
Analitika
Post Prodigy
3 years ago

Load 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-zhangti's avatar
    v-zhangti
    Community 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's avatar
      Analitika
      Post Prodigy

      Do I need select all columns to make active parse button?