One of the latest data sources in Power BI is JSON(JavaScript Object Notation). It is the way of transferring data and can move data from one place to another like XML. There are some differences in which the data is actually tagged within a file. Basically, it is a method of exchange data. Similar to XML, itself prescribes and uses tagging method to tell about the data.
You can follow these steps:
Step 1: Click on get data
Step 2: Check the JSON file
Step 3: upload the file from your system
On clicking on Open, the JSON data will be loaded into the Query Editor window. The loaded data represents the JSON root node which will be present as a single row. Click on ‘Record’ to drill down to the list of records.
Step 4: Click on list and drill down to individual records
Step 5: Now that we have a record for each item in the JSON File. This can be converted to the Power BI table by selecting the ‘To Table’ option.
Step 6: It will give us the option to select which column should be part of the table. You have to make sure that you would uncheck the checkbox ‘Use original column name as prefix’. In case it is checked, the generated column will have the naming convention ‘Column1.NewColumnName’.
Step 7: Click on ok and apply and save
If u want to learn the tool in depth, then come to us and sign up for this Power BI training at Intellipaat.
Learn Power BI Course from this video :
:
Back