Delete data from streaming API with REST API

[justmeakinna]

Hello all, 

I'm working with an embedded report using the various REST API's provided by Power BI. Embedding, showing the report, updating, everything works except for deleting the data. 

I can delete data when I use the API on the Power BI website (https://docs.microsoft.com/en-us/rest/api/power-bi/pushdatasets/datasets_deleterowsingroup). But whenever I try to call this API from my Postman I get a 401 error. This error is very strange to me as I am capable of using the same bearer token provided by my account + oauth2/token to get all report in a group as well as get an embed token for a report. 

Could anyone help me as to why I can't call this delete method in my Postman but I can when using the website mentioned above?

My postma is as follows:

https://api.powerbi.com/v1.0/myorg/groups/{group-id}/datasets/{dataset-id}/tables/{table-name}/rows

with a header, key = Authorization, value = Bearer ey......

[v-robertq-msft]

Hi, @justmeakinna 

According to your description and the link you posted, it seems like the API you used can only work for push datasets:

You can try to follow this document to delete datasets in group using rest api:

https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/deletedatasetingroup

Here are some links related to the problem you encountered, you can also take a look:

https://community.powerbi.com/t5/Developer/401-when-accessing-any-Power-BI-API-endpoints/m-p/335613

https://community.powerbi.com/t5/Developer/Power-Bi-REST-API-401-Authorization-error-when-using-app-...

https://stackoverflow.com/questions/53866456/power-bi-rest-api-401-authorization-error-when-using-ap...

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.