cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Twan Regular Visitor
Regular Visitor

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
PowerBIGuy Member
Member

Re: Limit Stream Analytics Data by Time

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

Business Intelligence Architect / Consultant
Power BI Team julie
Power BI Team

Re: Limit Stream Analytics Data by Time

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.

fbrossard Member
Member

Re: Limit Stream Analytics Data by Time

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

Helpful resources

Announcements
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Users Online
Currently online: 39 members 941 guests
Please welcome our newest community members: