CODEWITHSUNDEEP
jsonpowerbi
Such Much Code
Such Much Code

Reputation: 827

Power BI and JSON data

Is it possible to make Power BI read JSON data? I've spent an entire day yesterday to figure out how to convert the JSON data into a readable table in Power Bi, but with no luck.

I tried googling for hours, but there is no proper documentation anywhere.

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

Maybe there are any tutorials I can follow? Or perhaps another alternative to Power BI that would properly read and structure my JSON data?

Upvotes: 5

Views: 12647

Answers (3)

developer_.net
developer_.net

Reputation: 346

This Answer may help now..

First We have to convert this to table ->Click on the Icon in top left corner Icon label : To Table

Properties window will open. dont change anything Click on Ok.Now you can see the list converted to Column.

There is an arrow icon in the column -> Click on it

Arrow Icon

Main Step :In the property window uncheck "use original column name as prefix"

Here we go You can now use this result !

You will get tabular result from JSON

Refer Below Links :

https://www.mssqltips.com/sqlservertip/4621/using-power-bi-with-json-data-sources-and-files/

https://www.dutchdatadude.com/loading-multiple-json-files-using-power-query/

Upvotes: 4

user2063329
user2063329

Reputation: 453

Retrieving data from a .json file brings in 'Records'. Each row of data is returned as a 'Record' which is a List. Each record in 'Records' is a hyperlink that opens the row elements. You could convert the 'Records' into a table, but you get a Table with a single column which has all the records with each record a row from the original JSON data.

Here is a link to few more details: http://hodentekmsss.blogspot.com/2016/11/retrieving-json-data-in-power-bi.html

Upvotes: 0

Vasim
Vasim

Reputation: 3143

As mentioned in comments, just besides each Record (if headers), are you able to see any small box with two arrows, try clicking it.

Upvotes: 7

Related Questions