Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
AndrewGoal
Regular Visitor

Input Json placed in azure storage blob to Power BI

Hello guys,

I'm trying to get JSON file data from AZURE BLOB STORAGE generated from Stream Analytics, when I load it in P. BI it shows me only columns and not data.

Someone can tell me how I can make reports on Power BI using Json as source?

 

thanks

Andrew

1 ACCEPTED SOLUTION
v-yulgu-msft
Microsoft Employee
Microsoft Employee

Hi @AndrewGoal,

 

Did you get any error message? After loading JSON file to Power BI, we need to convert records to table in Query Editor, can you see that option in your scenario? Besides, here is a similar thread, please check whether it helpful to you.

 

Best regards,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
tmevandamme
Microsoft Employee
Microsoft Employee

In case anyone else is having this issue still - when you connect to the blob storage and then load the json, within the power query, click on the "combine files" button on the "content" column.

This article shows how to do it with an excel. It works the same for json.

How to access data from Azure Blob Storage using Power BI (sqlshack.com)

v-yulgu-msft
Microsoft Employee
Microsoft Employee

Hi @AndrewGoal,

 

Did you get any error message? After loading JSON file to Power BI, we need to convert records to table in Query Editor, can you see that option in your scenario? Besides, here is a similar thread, please check whether it helpful to you.

 

Best regards,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
AndrewGoal
Regular Visitor

Hello guys,

I'm trying to get JSON file data from AZURE BLOB STORAGE generated from Stream Analytics, when I load it in P. BI it shows me only columns and not data.

Someone can tell me how I can make reports on Power BI using Json as source?

 

thanks

Andrew

Hi, check out this video

https://youtu.be/uX2idV79P24

It might help.

I got it, unfortunally I've followed this document:

https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-twitter-sentiment-analysis-...

 

but it seem make json file not correct, there are only rows data, because Power BI doesn't able to manage it.

😞

 

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.