The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Solved! Go to 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
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)
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
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
I got it, unfortunally I've followed this document:
but it seem make json file not correct, there are only rows data, because Power BI doesn't able to manage it.
😞
User | Count |
---|---|
74 | |
70 | |
39 | |
30 | |
28 |
User | Count |
---|---|
104 | |
95 | |
51 | |
48 | |
46 |