Forum Discussion
Plotting multiple points in one single event
Hey guys,
This is the situation:
I am sending data from azure to power bi through a stream analytics job. I was able to plot one single point vs time in every event I sent from azure to powerbi. The thing now is that I want to plot several points in one single event from azure to powerbi, Could that be possible in some way?
This is the data I send to powerbi:
[
{
"V1": 93.57827534934525,
"V2": 34.91722801668005,
"V3": 42.54934529271297,
"timestamp": 1527848201,
"EventProcessedUtcTime": "2018-06-01T10:17:05.3485519Z",
"PartitionId": 1,
"EventEnqueuedUtcTime": "2018-06-01T10:16:49.2130000Z",
"IoTHub": {
"MessageId": null,
"CorrelationId": null,
"ConnectionDeviceId": "NetPI",
"ConnectionDeviceGenerationId": "636625164167937534",
"EnqueuedTime": "2018-06-01T10:16:49.1730000Z",
"StreamId": null
}
},
{
"V1": 83.86097741057826,
"V2": 20.011153004817082,
"V3": 35.73305430565414,
"timestamp": 1527848202,
"EventProcessedUtcTime": "2018-06-01T10:17:05.3485519Z",
"PartitionId": 1,
"EventEnqueuedUtcTime": "2018-06-01T10:16:49.2130000Z",
"IoTHub": {
"MessageId": null,
"CorrelationId": null,
"ConnectionDeviceId": "NetPI",
"ConnectionDeviceGenerationId": "636625164167937534",
"EnqueuedTime": "2018-06-01T10:16:49.1730000Z",
"StreamId": null
}
}, .... more here
As you can see I have several objects with a timestamp each one but this is sent in a single event. How could I plot all the points? So far I can only plot the first single object :(
Thank you in advance
Regards, Alex
2 Replies
Hi AFdez,
You may use restful api to get steam data from azure stream analytics, for details, please refer to:
https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-power-bi-dashboard
Regards,
Jimmy Tao
First of all, thank for your answer.
Anyway, I think you didn't understand me very well, I think I was not clear enough... my fault.
Let me explain again:
From azure, in every event, I send one array of 10 elements, and each element is an object with readable data to be plotted by powerbi. The problem is that so far, the powerbi only recognize the data inside the first object of the first element every time I send an event.
Let's say that I want to plot voltage vs time, then until now, I can plot one voltage value in every event sent, that is OK.
But now I send 10 voltages values vs their timestamps at one time (one event) and I'd like to plot them in real time.
I hope that serves.
Regards, Alex
