Calling Power BI API from Azure Logic App

[MrRichDean]

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]

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]

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]

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?!

[lbendlin]

You went through here, right?

https://docs.microsoft.com/en-us/rest/api/power-bi/apps

[MrRichDean]

Good morning @lbendlin 

I'm not 100% sure if my admin did this part of the process so I shall check with them and let this post know either way.