Live streaming without history of data.

[SathishPBI]

Dear All,

i want to show the help desk site status (up/Down) and location using power BI real time. so i have used livestream dataset to implement the concept like

1. in sharepoint list i have stored all site location.

2. check error status mail and get the site status (up/ down) using MS FLOW.

3. using MS flow to update status in sharepoint list item

4. upload all site details into power bi live streaming data set.

 these all working fine but the problem is 

Q:

All previous data in data set, so its not clearing old data and update only new datasets. 

I have unchecked "History data" option then i cant see any data in power bi

Any has idea how to implement my concept or how to clear old data before storing my new data in live streaming data set?

help is greatly appreciated

[SathishPBI · Accepted solution]

Finally got solution to show only latest data (status) using livestreaming with history data enabled.

1. clear live data set with REST APIs call (custom API for MS flow)

2. sync the latest data to live streaming dataset.