Hello Friends,
Below are the steps to open multi layer JSON file into Power BI.
Note: if you open from files system then use JSON file datasource or if you open from any url then you can use WEB and rest of the steps will be the same.
Step 01: Open “Get Data” and click “More…”
Step 02: Select File>>JSON files option.
Step 03: Select file.
Step 04: You will see document levels and “Record” link which holds data in it. Go to second level’s “Record” section and right click and select “Drill Down“.
Step 05: Right click on first “Record” and click on “Into Table“.
Step 06: Now you will able to see your data just you need to expand the columns by clicking button on “Value” column. {I used to clear “use original column name as prefix” option as it adds prefix before you column’s name}
Step 07: Click OK and you will able to you final dataset.