PowerBINotAuthorizedException ServicePrincipal despite all access done

BoNDoK00 — Fri, 02 Dec 2022 16:53:30 GMT

I want to use Power BI PowerShell module. This is what I have done:

1. I got Power BI Moduel installed in PowerShell

2. I got an app registered with the following permissions:

(This message is shown on the top of the permissions screen)

3. I added the Service Principal to a security group and granted him access in Power BI Admin Portal:

E.g.

4. I authenticate in Power Shell using this code:

$client_id = <> $tenant_id = <> $secret = <> $SecurePassword = ConvertTo-SecureString $secret -Force -AsPlainText $servicePrincipal = New-Object -TypeName PSCredential -ArgumentList $client_id, $SecurePassword Connect-PowerBIServiceAccount -ServicePrincipal -Credential $servicePrincipal -Tenant $tenant_id

5. I try to call APIs from PowerShell:

Invoke-PowerBIRestMethod -Url 'https://api.powerbi.com/v1.0/myorg/admin/groups/<Group ID>/users' -Method Get

I get the following error message:

Invoke-PowerBIRestMethod : One or more errors occurred. At line:1 char:1 + Invoke-PowerBIRestMethod -Url 'https://api.powerbi.com/v1.0/myorg/adm ... + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : WriteError: (Microsoft.Power...werBIRestMethod:InvokePowerBIRestMethod) [Invoke-PowerBIRestMethod], AggregateException + FullyQualifiedErrorId : One or more errors occurred.,Microsoft.PowerBI.Commands.Profile.InvokePowerBIRestMethod Invoke-PowerBIRestMethod : Encountered errors when invoking the command: { "code": "PowerBINotAuthorizedException", "pbi.error": { "code": "PowerBINotAuthorizedException", "parameters": {}, "details": [], "exceptionCulprit": 1 } } At line:1 char:1 + Invoke-PowerBIRestMethod -Url 'https://api.powerbi.com/v1.0/myorg/adm ... + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : WriteError: (Microsoft.Power...werBIRestMethod:InvokePowerBIRestMethod) [Invoke-PowerBIRestMethod], Exception + FullyQualifiedErrorId : Encountered errors when invoking the command: { "code": "PowerBINotAuthorizedException", "pbi.error": { "code": "PowerBINotAuthorizedException", "parameters": {}, "details": [], "exceptionCulprit": 1 } },Microsoft.PowerBI.Commands.Profile.InvokePowerBIRestMethod

Can you please assist me to know what did I miss?

Thanks

Re: PowerBINotAuthorizedException ServicePrincipal despite all access done

Daryl-Lynch-Bzy — Fri, 02 Dec 2022 22:28:16 GMT

Hi @BoNDoK00 , it looks like you are trying to connect using a Service Principal to use the Power BI Admin Rest API. There is an important part in the documentation: Enable service principal authentication for read-only admin APIs - Power BI | Microsoft Learn

If you delete all the Power BI API setting in the Azure Portal the "PowerBINotAuthorizedException" should be avoided.

Re: PowerBINotAuthorizedException ServicePrincipal despite all access done

halamsjah — Thu, 22 Dec 2022 22:13:43 GMT

I have similar issue and got the same error but only for some workspaces. For most of the other workspaces, the powershell script works fine.

topic Re: PowerBINotAuthorizedException ServicePrincipal despite all access done in Developer

PowerBINotAuthorizedException ServicePrincipal despite all access done

Re: PowerBINotAuthorizedException ServicePrincipal despite all access done

Re: PowerBINotAuthorizedException ServicePrincipal despite all access done