Is there a way to convert JSON data to readable table in power bi

Question

Is it possible for power bi to read JSON data? I’ve been trying from a really long time to find this, but no luck as of now!

I want my JSON data to be converted into a readable table.

I'm retrieving a JSON payload from my website and when I try to import, it shows the data like this:

Record
Record
Record
Record

 Thank you

Answer 1

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 : 

: