topic Re: REST API call from Power Automate in Developer

REST API call from Power Automate

Anonymous — Fri, 31 Dec 2021 16:48:05 GMT

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?

Re: REST API call from Power Automate

lbendlin — Sun, 02 Jan 2022 01:50:09 GMT

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.

Re: REST API call from Power Automate

V-lianl-msft — Tue, 04 Jan 2022 03:23:08 GMT

Hi @Anonymous ,

You can refer to these blogs:

https://community.powerbi.com/t5/Community-Blog/Custom-Connector-in-Power-Automate-Microsoft-Flow-for-Power-BI/ba-p/1224350

https://data-marc.com/2020/01/13/manage-all-your-power-bi-refreshes-in-one-place-with-power-automate-flow/

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.

Re: REST API call from Power Automate

Anonymous — Tue, 04 Jan 2022 11:31:11 GMT

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'