Forum Discussion

kranthi_sunkara's avatar
kranthi_sunkara
Regular Visitor
4 years ago

Connecting PowerBI from Power Shell without prompting

I am trying to connect powerBI from powershell. I created a service account in azure AD and enabled service prinicipal in powerBI under admin portal. I am using the below commands. $password = "xx...
Need Help
kranthi_sunkara's avatar
kranthi_sunkara
Regular Visitor
4 years ago

No luck for me 😞 Getting error again. Not sure if it needs any permissions.

 

Connect-PowerBIServiceAccount -ServicePrincipal -CertificateThumbprint xxxx -ApplicationId xxxxxx -Tenant xxxxxxxxxx

 

 

Connect-PowerBIServiceAccount : One or more errors occurred.
At line:1 char:1
+ Connect-PowerBIServiceAccount -ServicePrincipal -CertificateThumbprin ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : WriteError: (Microsoft.Power...IServiceAccount:ConnectPowerBIServiceAccount) [Connect-Po
werBIServiceAccount], AggregateException
+ FullyQualifiedErrorId : One or more errors occurred.,Microsoft.PowerBI.Commands.Profile.ConnectPowerBIServiceAcc
ount

Anonymous's avatar
Anonymous
Not applicable
4 years ago

If you haven't already, you'll need need to install that certificate at either the user level or machine level on the machine that's running that powershell script. My AD guy created a PFX export of the certificate and that was installed on the server that's running my script. I can't speak to how the export was created (that's certainly not my domain) but maybe you do. 

  • kranthi_sunkara's avatar
    kranthi_sunkara
    Regular Visitor
    4 years ago

    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      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. 

       

      • kranthi_sunkara's avatar
        kranthi_sunkara
        Regular Visitor
        4 years ago

        It was added already. 

        When adding a service prinicipal to the workspace, does it require admin permissions?