Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi
I am trying to run the following API calls in Power Automate to get the history, and refresh the datasets:
GET https://api.powerbi.com/v1.0/myorg/groups/{groupId}/datasets/{datasetId}/refreshes
POST https://api.powerbi.com/v1.0/myorg/groups/{groupId}/datasets/{datasetId}/refreshes
I can run a single call of POST, I get a status code of 202, but if I try to run the same call in a loop I get a 401. The call is exactly the same other than there is a loop and the API is called multiple times.
You have to first get a token for the authorization, I have tried both a single call before the loop and within the loop, still the same error.
Any ideas please?
Solved! Go to Solution.
Grrrr, I am so annoyed, but also very happy.
I have found my error. Its not because of the loop, that was a red herring! What it was and the reason why it's so annoying is, as part of the http REST API call is your header. This has your autorization, to the left you have Bearer and your access_token which you have picked up already. The trick is
MAKE SURE YOU HAVE A SPACE AFTER 'Bearer'
Hi @Anonymous ,
You can refer to these blogs:
In addition, you should also note that the pro license can be refreshed 8 times a day and the Premium capacity can be refreshed 48 times a day.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Grrrr, I am so annoyed, but also very happy.
I have found my error. Its not because of the loop, that was a red herring! What it was and the reason why it's so annoying is, as part of the http REST API call is your header. This has your autorization, to the left you have Bearer and your access_token which you have picked up already. The trick is
MAKE SURE YOU HAVE A SPACE AFTER 'Bearer'
1. Write your own custom connector. Swagger file examples can be found on the interwebs
2. Power Automate has a ready-made action to request the refresh of a Power BI dataset. That could take care of your second request.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
6 | |
6 | |
3 | |
2 | |
2 |