Calling Power BI API from Azure Logic App

MrRichDean · ‎09-14-2020

Good morning / afternoon / evening

Would anyone be able to list the precise steps I need to perform in order to fire off a HTTP request to the Power BI api from within an azure logic app?

I have been attempting to follow the articles below:

https://carldesouza.com/how-to-register-an-azure-app-to-use-with-power-bi/

https://carldesouza.com/how-to-authenticate-and-use-the-power-bi-api-inside-power-automate/

To date, I haven't even got as far as to getting the access token and I am finding it rather infuriating!

Currently, I am stuck with the following error:

"error": "invalid_grant",

"error_description": "AADSTS65001: The user or administrator has not consented to use the application with ID

However, rather than looking at this specific error, I am thinking I may have to take a few steps back, hence my original question.

If anyone can point me in the right direction or give me some pointers, I'd be most grateful.

Anonymous · ‎04-25-2022

Hi @MrRichDean,

what kind of Power BI Rest API request are you using? If you want to use Admin API's with application your application has to have API permissions without Admin consent required option.

Instead of Yes in my picture you should have No.

lbendlin · ‎09-14-2020

the error message is pretty accurate. You first need to register the app, and make sure to specify the correct desired permission scope. Then your admin needs to agree to that app request. Then you can use the app's authentication method to run your Power BI API calls.

MrRichDean · ‎09-14-2020

Hello @lbendlin

Could you explain what you mean regarding the correct desired permission scope? How does my admin agree to the app request? Am I even correct in that I need to get an access token before calling the Power BI API ?

Currently I am doing the following call to get the access token :

MY admin believes they have agreed to eveything he can find - what are they missing?!