Solved
Service Principle cannot Get-PowerBIWorkspace
Hi,
I'm trying to use the Power BI Rest API via Powershell authenticating with my service principle to retrieve a workspaceid for a given named workspace via "Get-PowerBIWorkspace", unfortunately I receive "Get-PowerBIWorkspace : Operation returned an invalid status code 'Unauthorized'"?? Do service principles not have access to this API? I can access via "Login-PowerBIServiceAccount" authenticating with my Power BI Admin account so I guess not. How can I re-write the below for the APIs a service principle can access?...
$WorkspaceName = "Test Workspace"
#Get PBI workspace attributes
$Workspace = Get-PowerBIWorkspace -Scope Organization -Name $WorkspaceName
$WorkspaceId = $Workspace.Id
Write-Host "Workspace ID: "$WorkspaceId
Fixed this by removing "-Scope Organization"
That was surprisingly easy 🙂
