Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Realtime reporting - Delete streaming data in Push mode

Hello everyone, 

 

I want to do realtime reporting in PowerBI using Stream analytics.  I have everything setup and works fine.. Now I want to show active users in a map for a particular timeframe only (say for last 10 mins).  Using only streaming mode Maps are not possible.  Using hybrid mode, data is incremental and now challenge is how to get only LAST 10 mins data on dashboard ?  I saw something like PowerBI rest API's for Deleterows but again I am not completely clear on how and exactly when/where to call it from once my job is running?  OR to put in other words, is there any way I can view my live data in PowerBI dashboard for a particular timeframe?  Like for example in a map I plot active users coming from Stream analytics which keeps aggregating, but I want to see only last 5 mins data or may be 5 mins of data before an hour?  Is anything like this possible.  Please suggest solution or alternatives around this...

Need Help

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    HI Anonymous,

     

    I don't think delete row is a option, the simple way is add advanced filter with 'topn' filter model to filter records.
    Choose a suitable number will achieve only display last records on map visual based historic dataset.

     

    Regards,

    Xiaoxin Sheng

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi Xiaoxin,

       

      Thanks for your inputs.  The problem is I don't have any fix number of records to fetch..I want data for a particular timeframe, so how do I achieve that?

       

      Regards,

      M

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        HI Anonymous,

         

        AFAIK, most of edit feature not available in power bi service side.

         

        Maybe you can try to get data form power bi service, then write a measure to check matched records and drag to visual level filter to control display records.

         

        Notice: normal filter/slicer not accurate enough to achieve last n minutes filter effect.

         

        Regards,

        Xiaoxin Sheng