Limit Stream Analytics Data by Time

[Twan]

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".

[fbrossard]

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

[julie]

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.

[PowerBIGuy]

Try creating a numbered index or rank column based on date and use this coulmn to filter your dataset.