Forum Discussion
Connecting PowerBI from Power Shell without prompting
I was able to login successfully without popup using the below command. For credentials, I used appid and secret as username and password.
Connect-PowerBIServiceAccount -ServicePrincipal -Credential $Creds -Tenant $TenantId
But now, I am having issues retrieving the workspace I need. I am trying to retrive my workspace using workspace id. But I am getting unauthorized error. Does the user I am using should be admin?
Get-PowerBIWorkspace -Id xxxxxxxxxx
Error:
Get-PowerBIWorkspace : Operation returned an invalid status code 'Unauthorized'
At line:1 char:1
+ Get-PowerBIWorkspace -Id xxxxxxxxxxxxx
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : WriteError: (Microsoft.Power...owerBIWorkspace:GetPowerBIWorkspace) [Get-PowerBIWorkspace], HttpOperationException
+ FullyQualifiedErrorId : Operation returned an invalid status code 'Unauthorized',Microsoft.PowerBI.Commands.Workspaces.GetPowerBIWorkspace
If you haven't already, you'll need to add that app registration to an AD security group. Then, you'll need to add that security group in the Power BI Admin Portal under the Admin API settings.
It was added already.
When adding a service prinicipal to the workspace, does it require admin permissions?
If you're referring to Admin API permissions thorugh the App regisration then no. Don't add any API permissions. Microsoft specifically calls this out in one of their articles.
All good now. Everything working for me. Thanks for your help.
Good to hear. Happy to help.