Forum Discussion
zandora
2 years agoRegular Visitor
How to delete all rows from a streaming dataset using API?
Hy all, I want to know how we can delete all rows in a streaming database PowerBi using API. I have created an app in Azure with the below permissions. And tried to send POST call to get t...
Anonymous
2 years agoNot applicable
Thanks for the reply from lbendlin , please allow me to provide another insight:
Hi zandora ,
First get the corresponding datasetID with a get request:
GET https://api.powerbi.com/v1.0/myorg/groups/{group-id}/datasets
Authorization: Bearer {access-token}
Then use a delete request to remove all rows:
DELETE https://api.powerbi.com/v1.0/myorg/groups/{groupId}/datasets/{datasetId}/tables/{tableName}/rows
For more details, you can refer to below document:
Datasets - Get Datasets In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn
Best Regards,
Adamk Kong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.