Power BI and JSON data

[kosmik5]

Hi,

Is it possible to make Power BI read JSON data? I've spent an entire day 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?

Thank You

Hari

[WolfBiber · Accepted solution]

Hey,

you have to convert the objects to a table