Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

REST API call from Power Automate

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}/refresh...
Need Help
Show and Tell
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    4 years ago

    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'

V-lianl-msft's avatar
V-lianl-msft
Icon for Community Support rankCommunity Support
4 years ago

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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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'