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 o...
Need Help
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

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Thanks Xiaoxin, but still doesn't sound like a feasible solution to my problem.  Looks like this is not possible as of now in PowerBI

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Hi Anonymous,

         

        >>Looks like this is not possible as of now in PowerBI

        As document mentioned, you can't direct operate streaming dataset.

         

        It is possible to view or use api to operate on stored history records if you turn on historic option.

         

        In addition, power bi service also not contain accurate enough filter features on to achieve your requirement.

         

        Regards,

        Xiaoxin Sheng