How to send only the last value received from stream analytics to powerbi

Question

How can I send and keep only the last value sent from stream analytics to powerbi?

I am measuring temperatures per sensor and sending to an eventhub and then to stream analytics then I am sending that further to powerbi. But I donot want all values in a table in powerbi. I want just the last measured value to appear in powerbi.

The reason is that I want to show in a single tile just the last measured sensor value for one of the sensors. I was not able to find a way to that if I send all measurements from stream analytics to powerbi as there are no filters that let me select only the maximum of date time values for example.

How to do that?

Answer 1

We're looking at how to do this in a better way, but there's a pretty simple procedure for making this work:

Use the "Ask a question about the data on this dashboard" box (QnA) and use a question like the following: "Average speed in the last 10 seconds"

This will give you what you want.

HTH, -Lukasz

Signup: http://www.powerbi.com

Power BI Developer Blog: http://blogs.msdn.com/powerbidev

Developers: http://dev.powerbi.com

Support: http://support.powerbi.com