topic Re: Calling Power BI API from Azure Logic App in Developer

Calling Power BI API from Azure Logic App

MrRichDean — Mon, 14 Sep 2020 12:36:28 GMT

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.

Re: Calling Power BI API from Azure Logic App

lbendlin — Mon, 14 Sep 2020 13:35:41 GMT

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.

Re: Calling Power BI API from Azure Logic App

MrRichDean — Mon, 14 Sep 2020 13:46:15 GMT

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

Re: Calling Power BI API from Azure Logic App

lbendlin — Mon, 14 Sep 2020 15:40:57 GMT

You went through here, right?

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

Re: Calling Power BI API from Azure Logic App

MrRichDean — Tue, 15 Sep 2020 08:09:05 GMT

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.

Re: Calling Power BI API from Azure Logic App

Anonymous — Mon, 25 Apr 2022 13:27:41 GMT

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.