Explanation Step 1: Expand the records. First Open Power BI desktop and navigate to Power Query, import the JSON file, then load the data, click on the record to expand it and to see the record and list. Step 2: Add columns that use data type conversions. Step 3: Convert the list to a table