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

Need Help

5 Replies

    • lbendlin's avatar
      lbendlin
      Super User
      2 years ago

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

      • zandora's avatar
        zandora
        Regular Visitor
        2 years ago

        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 

  • 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