Record Data Not Expanding From Streaming Data Set

[josmendez]

Hello,

I am newer power BI user and I am running into an issue with seeing the data I am pushing in PowerBI from a Stream Analytics Job that is connected to my IoT hub. 

I can see that the data get to the Job fine and it seems get to PowerBI, but it become a non expandable record as seen in the image below:

I suspect this is possibly an issue with how I am formating the data that is being sent into power bi. You can a sample of the format below:

Is there a way to expand the record that I am missing? Or do I need to use different formatting to pass the data?

I am attempting to pass an RTD event and then a bunch of data underneath that if possible.

Thank you for your help!

[josmendez]

Thank  you very much! Both of those links were very helpful!

[v-kkf-msft · Accepted solution]

Hi @josmendez ,

Try ro refer to

Stream Analytics and Power BI: A real-time analytics dashboard for streaming data 

Parse JSON and Avro data in Azure Stream Analytics 

to convert array elements into separate events. The APPLY operator together with the GetArrayElements built-in function extracts all array elements as individual events. 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.