Forum Discussion
Limit Stream Analytics Data by Time
Hello I was wondering if there is any way to limit the amount of stream analytics by time that is used in the data set in Power BI. For example I have a requirement to only show the last days Stream Analytics data in the dashboard. But the only time filters that can be used on the reports are to allow data before or after a certain date. It would be useful if there was a time filter for "Last X Hours" or "Last X Days".
3 Replies
Try creating a numbered index or rank column based on date and use this coulmn to filter your dataset.
You can also try to create a Q&A visual with "in the last x days/hours/minutes/seconds" for the time window you want, then pin it to the dashboard.
Hi,
You can simply modify your query in Stream Analytics by adding a where clause and using dateadd function
https://msdn.microsoft.com/en-us/library/azure/dn834997.aspx
