Such Much Code Such Much Code - 1 year ago 200
JSON Question

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:


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

Answer Source

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

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download