Intellipaat Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in BI by (17.6k points)

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? 

closed

1 Answer

0 votes
by (47.2k points)
selected by
 
Best answer

Just beside each Record (headers), you will be able to see small box with two arrows. Try clicking it

Related questions

0 votes
1 answer
asked Jul 3, 2019 in BI by Vaibhav Ameta (17.6k points)
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
asked Feb 15, 2021 in BI by Chris (11.1k points)

31k questions

32.8k answers

501 comments

693 users

Browse Categories

...