Input Json placed in azure storage blob to Power BI

[AndrewGoal]

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

[tmevandamme]

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 · Accepted solution]

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

[AndrewGoal]

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

[davehus]

Hi, check out this video

https://youtu.be/uX2idV79P24

It might help.

[AndrewGoal]

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.

😞