Forum Discussion

kosmik5's avatar
kosmik5
Regular Visitor
8 years ago
Solved

Power BI and JSON data

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

1 Reply

  • WolfBiber's avatar
    WolfBiber
    Microsoft Employee

    Hey,

    you have to convert the objects to a table