topic Re: Unauthorised when using Get-PowerBIWorkspace in Developer

Unauthorised when using Get-PowerBIWorkspace

cokiedo — Fri, 12 Jan 2024 17:33:37 GMT

I am connecting to powerbi service the following command but get an unauthorised message. Which specific api permissions are needed to be able to retrieve PowerbiWorkspace.

Connect-PowerBIServiceAccount -CertificateThumbprint $CertThumbprint -ApplicationId $Appid -Tenant $TenantID -ServicePrincipal

Get-PowerBIWorkspace : Operation returned an invalid status code 'Unauthorized'
At line:2 char:14
+ $workspace = Get-PowerBIWorkspace -Name $workspaceName
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : WriteError: (Microsoft.Power...owerBIWorkspace:GetPowerBIWorkspace) [Get-PowerBIWorkspace], HttpOperationException
+ FullyQualifiedErrorId : Operation returned an invalid status code 'Unauthorized',Microsoft.PowerBI.Commands.Workspaces.GetPowerBIWorkspace

I have setup these api permissions already:

Re: Unauthorised when using Get-PowerBIWorkspace

Anonymous — Mon, 15 Jan 2024 02:43:09 GMT

Hi @cokiedo ,

It would appear that your account does not have access to view all the workspaces.
Confirm with your admin that your account is part of the Power BI Admin Group.

Refer to:

Solved: Can't access entire organizational datasets using ... - Microsoft Fabric Community

This is the related document, you can view this content:

Solved: Get-PowerBIActivityEvent - throws Unauthorized err... - Microsoft Fabric Community

Operation returned an invalid status code 'Unautho... - Microsoft Fabric Community

Solved: Service Principle cannot Get-PowerBIWorkspace - Microsoft Fabric Community

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.