How to delete all rows from a streaming dataset using API?

[zandora]

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 the database details in the workspace. But I got the below error

Please advice where I am wrong, I believe all the permissions are clear.

[Anonymous]

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

Push Datasets - Datasets DeleteRowsInGroup - REST API (Power BI Power BI REST APIs) | Microsoft Lear...

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.

[zandora]

Hi @Anonymous ,

Thankyou for your response, I tried but it was a failure.

The below image shows it was not working as same.

I am generating token as demonstrated below;

But when I tried using login to this guide I was able to get it successful. I believe I am creating the token in the wrong way.

The below are the API permission with admin consent;

Please let me know how we create the auth token if I am doing it wrong

[zandora]

@hackcrr , @SaiTejaTalasila , @lbendlin , @ibarrau  Please advise me, thanks in advance..

[lbendlin]

use jwt.io to check if your token actually has that scope.

[zandora]

Thankyou for your response, I tried to decode the authorization code but I didn't see anything regarding the access details. Please let me know the proper way to request Authorization code. I believe that's where I am wrong