Delete rows from dataset with REST API

[flennon]

I can't seem to find any documentation on how to delete data from a push dataset using a Delete request with the API. Is that functionality available?

As there is no rolling hour filtering capabilities on reports/visuals, I want to delete any rows in the dataset older than X number of hours using the API. This way I dont have to filter the report but it would always display the last X number of hours.

Any Advice would be greatly appreciated.

[v-jiascu-msft · Accepted solution]

Hi @flennon,

There is a REST API called datasets_deleterowsingroup. But it will delete all the rows. Maybe you can give it a try.

Best Regards,

Dale

[Felix_Schulte]

Where do I get the missing variable values?

E.g.  "myorg", data set id?

Do I need an API key or some other auth token?

The doc says to use this URL for DELETE

https://api.powerbi.com/v1.0/myorg/datasets/cfafbeb1-8037-4d0c-896e-a46fb27ff229/tables/Product/rows

But Power BI Desktop gives me such an URL for POST

https://api.powerbi.com/beta/79a1372c-xxxx-4a82b7/datasets/3ff8-xxxx-7130265/rows?key=fgEBgY2enyf0xz...

So, how to construct a valid DELETE URL?