locked
Stream Analytics temporal queryes to PowerBi RRS feed

  • Question

  • Hi, i'm new to Azure and i'm having a issue trying to make temporal query consulting to send data to POWER BI.

    I have the following query:

    SELECT id, pais, temp, vel, son, lon, lat, hora, dia, colisao, multa, motor, System.timestamp as time, COUNT(*)
    FROM fakentrance TIMESTAMP BY time
    GROUP BY
    id, pais, temp, vel, son, lon, lat, hora, dia, colisao, multa, motor,
    TUMBLINGWINDOW(s, 2)

    What i need to do is show real-time data, like if i want to show the real temperature i can use a gauge to show the variation.
    How can i do the query so i can show this?
    My application sends data to Service Bus in every 1.5 secs

    Thanks everyone.

    Thursday, March 3, 2016 4:44 PM

Answers

All replies