cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Using Azure Stream Analytics output with Power BI Desktop

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

1 ACCEPTED SOLUTION
Frequent Visitor

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.

View solution in original post

3 REPLIES 3
Frequent Visitor

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.

View solution in original post

Anonymous
Not applicable

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
Not applicable

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

The other tiles without Q&A goes faster.

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors