Forum Discussion
Power BI API : GET Refresh works, but POST does not
Hi,
I'm testing Dataset refresh through API with Postman.
I created and registered an app in AD with Dataset.ReadWrite.All Granted
When I send a GET resquest with a Bearer Token I get the history of refresh of the data set, but just changing the GET to a POST refresh to trigger a refresh send me back this answer :
I was trying to save you time but it seems like you insist on using Postman. So please verify this
Then verify that you added the App registration to a security group and at the tenant level
You should also know that a new token is generated every hour and you can only use POST https://api.powerbi.com/v1.0/myorg/datasets/xxxxx/refreshes up to 8 times a day for a shared workspace capacity, just like you schedule a refresh in the service.
So if you are planning on using retool.com then you know what to expect.
However I would recommend that you use Power Automate to create a button in your reports for an unlimitted on-demand refreshes.
7 Replies
- NicolasLJFrequent Visitor
Note : I use pro licence, I don't have a premium capacity.
I added the App and the group assigned to the app into the workspace as admin.
A is the security group assigned to the service principal and P is the Service principal.
I assigned Dataset.ReadWrite.All role in Azure and Granted by admin (Delegated)
My POST API setup :
And the answer :