Forum Discussion

zandora's avatar
zandora
Regular Visitor
2 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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 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.

  • zandora's avatar
    zandora
    Regular Visitor
    2 years ago

    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