Using Azure Stream Analytics output with Power BI Desktop

[Anonymous]

Hello,

does anybody knows, how can I implement a filter into a Azure Stream Analytics output?

My goal is, that I onlay get the data of the last 10 Minutes.

Can I implement a WHERE Condition?

E.g. WHERE MyDateTime > DATEADD(minutes, -10, GETDATE())

Thanks in advance

[BrentA · Accepted solution]

You have to ask the question using the "Q&A" functionality such as;

"Average temperature for the last 10 minutes"

Then you can edit this to how you want it to look and then pin it to your dashboard.

[Anonymous]

Thank you! Great idea and so simple 🙂

But the dashboard tiles do not automatically refresh?

Anyway - I'm going right in assuming that the stream data stored in the azure data lake (or something else) and it make no sense to filter the data in stream analytics, because the data is already in power bi? So I must filter the data in Power BI with Q&A or report filter etc and stream analytics only deliver the data/pumps the data into Power BI by the rules that are in the output definied.

[Anonymous]

Oh, the dashboard tiles automatically refreshs - but with a delay.

The other tiles without Q&A goes faster.