Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
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.
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.
Oh, the dashboard tiles automatically refreshs - but with a delay.
The other tiles without Q&A goes faster.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.