Parsing JSON, XML column in PowerBI

Let’s say you have a table with JSON or XML columns along with other columns. Below is the easiest way to parse JSON or XML columns in PowerBI.

Table with JSON column

Step 1: In the query editor, right-click on the column that has JSON or XML data.

Transform to JSON or XML

Step 2: Click on the expand button to select the required columns.

Expand column and select

The same method can be applied to columns with XML Data.