Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Twan
Advocate IV
Advocate IV

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 3
fbrossard
Advocate V
Advocate V

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
Employee
Employee

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
Responsive Resident
Responsive Resident

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

Business Intelligence Architect / Consultant

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors