Timeframe within a tumbling window RRS feed

  • Question

  • Hi guys,

    we are using ASA to collect realtime data from event hub and send this data to Power BI web app. Our query looks like this:

    SELECT System.Timestamp as LoginTime, Event, Portal, Count(*)INTO outputFROM input TIMESTAMP BY EventTimeGROUP BY TUMBLINGWINDOW(second, 1), Portal, Event

    How can I set a  timeframe about 2 hours for this data so that the Power BI web app is showing only the last 2 hours in a dashboard because theres no option to set a timeline in Power BI dashboards.

    Thursday, November 26, 2015 1:26 PM


All replies

  • Hi, Langevag

         We enable FIFO in Power BI. In another word, if you have high volume output (over 200k rows in last 15 minutes) PBI service will clean up old data).

        I suggest you to add feature request(ask for configurable of the FIFO window to something like 2 hours) to user voice of Power BI service.



    Thursday, December 3, 2015 6:59 PM
  • You can use Q&A in Power BI to ask for "last two hours" and you will get what you are asking for.
    Thursday, January 14, 2016 5:22 PM