topic Re: Power BI REST API gives 403 forbidden (use service principal) in Developer

Power BI REST API gives 403 forbidden (use service principal)

Anonymous — Sun, 13 Feb 2022 17:43:12 GMT

Hi everyone,

I want to get the powerbi dataset refresh history programmatically so I need to call the Power BI API using the below method,

GET https://api.powerbi.com/v1.0/myorg/groups/{groupId}/datasets/{datasetId}/refreshes

I follow the MS docs and this guide and created an app on Azure, and currently I can get the access token successfully but when I run the HTTP request it return 403 forbidden error,

The below is what I have tried but still the same error:

I grant almost all the PBI permission to this app (both delegate and application) as figure below,

I already added the app (service principal) as admin in my Power BI Workspace,

(I also enable Allow service principals to use Power BI APIs in PBI Admin portal)

I have tried to call the REST API on Power BI Desktop query editor and Postman, always return forbidden error. Below screenshot is where I tried on Power BI Desktop, I also can get the access token but still 403 when I try to use the token to call API.

So how do I fix this? anything missing? It cost me so much time but still cannot use the API successful.

Any solution would be much appreciated!

Re: Power BI REST API gives 403 forbidden (use service principal)

lbendlin — Sat, 05 Feb 2022 00:57:25 GMT

"added the app (service principal) as admin in my Power BI Workspace,"

But you are using an API call against Premium workspaces. Does your service principal have access to the Premium workspaces you are trying to access?

Re: Power BI REST API gives 403 forbidden (use service principal)

Anonymous — Sat, 05 Feb 2022 09:03:18 GMT

Hi @lbendlin , I granted my service principal as admin role in this premium workspace (as figure 3) so I believe it can access the content.

Re: Power BI REST API gives 403 forbidden (use service principal)

lbendlin — Mon, 07 Feb 2022 00:58:41 GMT

Have you considered using AAD auth instead?

migueesc123/PowerBIRESTAPI: A Microsoft Power BI Data Connector or Power Query Connector for the Power BI REST API (github.com)

Also, there's this:

Chris Webb's BI Blog: Connecting To REST APIs With OAuth2 Authentication In Power Query/Power BI Chris Webb's BI Blog (crossjoin.co.uk)

Re: Power BI REST API gives 403 forbidden (use service principal)

mholloway — Fri, 09 Feb 2024 03:52:38 GMT

Really frustrating that the "solution" is just a pointer to a totally different type of authentication and thereby does not resolve the posted problem at all.