topic Delete rows from dataset with REST API in Developer

Delete rows from dataset with REST API

flennon — Tue, 03 Jul 2018 14:52:52 GMT

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.

Re: Delete rows from dataset with REST API

v-jiascu-msft — Wed, 04 Jul 2018 08:09:20 GMT

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

Re: Delete rows from dataset with REST API

Felix_Schulte — Wed, 20 Jul 2022 15:19:07 GMT

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=fgEBgY2enyf0xzzzxxxxxBnQN5uGw%3D%3D

So, how to construct a valid DELETE URL?