Reset Streaming Dataset via API

[Anonymous]

Hi,

Is there any way I can programatically delete / reset the data within a streaming dataset which currently has historic data anlysis enabled?

I can push data just fine to the streaming dataset using a url similar to: 

https://api.powerbi.com/beta/6efabacde74-34aa-aaaa-bbbbb-ccccccc/datasets/abf4238eab-aaaaaa-503953-e...

But there's nothing documented on deleting all rows from a streaming dataset. Via the ui, the only solution that I have found to reset a streaming dataset's data is to turn "historical data analysis" off and then on again (see here Solved: Delete or reset a real-time dataset - Microsoft Power BI Community). 

I've found the following but doesn't seem applicable to streaming datasets:

Push Datasets - Datasets DeleteRows - REST API (Power BI Power BI REST APIs) | Microsoft Docs

Any help would be appreciated - it doesn't seem right that the only Api endpoint for streaming datasets is to push data. Some mechanis to purge / delete all data from a streaming dataset would make streaming datasets infinitely more useful. 

Thanks

[v-easonf-msft]

Hi, @Anonymous 

Please checking out the below post about deleting data from the Push dataset programmatically using Power BI Rest API’s and PowerShell.

How to delete data from push streaming dataset  

Best Regards,
Community Support Team _ Eason

[Anonymous]

This is very useful, thank you! Unfortunately powershell isn't an option due to org constraints (privileges, architecture). Would you be able to provide an example of a restful API call which can achieve the same results (still specifically for push streaming data sets with historic analysis toggled on)? My thoughts are that if it's possible via powershell, then it should be possible via curl or python requests. 

This seems to be a popular request amongs other users, in youtube video comments on the matter, and other threads. I would appreciate any help - it seems that users have been after this functionality for at least a few years. Thanks again.