Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
justmeakinna
Frequent Visitor

Delete data from streaming API with REST API

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

1 REPLY 1
v-robertq-msft
Community Support
Community Support

Hi, @justmeakinna 

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

v-robertq-msft_0-1615365525918.png

 

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.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.