Forum Discussion

kimlaurits's avatar
kimlaurits
Frequent Visitor
4 years ago
Solved

Add-PowerBIWorkspaceUser - adding group to Workspace

Hi, I am trying to automate different PowerBI tasks using a service principal. I can create new PowerBI Workspaces and the service principal is an admin on the Workspace. Afterwards I would like t...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    HI , 
    Below worked like a charm : 

     

    Add-PowerBIWorkspaceUser -Scope Organization -Id <workspaceid> -UserEmailAddress [email protected] -AccessRight Admin
    Ensure: You have Admin Rights to add the user. I tested it just now my user from which running API has Admin Rights on the workspace and its Premium ( to be considered if you are adding free user ) 

    Waiting for update 🙂 

    CHeers
    Mahak


     

kimlaurits's avatar
kimlaurits
Frequent Visitor
4 years ago

I tried it, but I get the same error:

Add-PowerBIWorkspaceUser : Operation returned an invalid status code 'NotFound'

 

It works when I add a user to a Workspace:

Add-PowerBIWorkspaceUser -Id <Workspace Id> -AccessRight Contributor -Identifier <User UPN> -PrincipalType User

Anonymous's avatar
Anonymous
Not applicable
4 years ago

HI , 
Below worked like a charm : 

 

Add-PowerBIWorkspaceUser -Scope Organization -Id <workspaceid> -UserEmailAddress [email protected] -AccessRight Admin
Ensure: You have Admin Rights to add the user. I tested it just now my user from which running API has Admin Rights on the workspace and its Premium ( to be considered if you are adding free user ) 

Waiting for update 🙂 

CHeers
Mahak


 

  • kimlaurits's avatar
    kimlaurits
    Frequent Visitor
    4 years ago

    Yes - the same works here, when adding a user.

     

    But unfortunately it doesn't work when adding a AD group.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Login-PowerBI

      #Using AD Security group

      $Body = @{
      identifier= “add your Odject ID here” #Object ID for the Security group
      groupUserAccessRight= “Admin” #Permission for the group to the Workspace
      principalType= “Group” #The type of Principal(App, Group, User)
      }

      $BodyJSON=$Body | ConvertTo-Json
      Invoke-PowerBIRestMethod -Method post -Url “/groups/Add your group Id here/users” -Body $BodyJSON #Workspace ID

       

      Can you trythis too. 

       

      This worked for me to add my Functional Email Group to the same workspace.


      Cheers 
      Mahak

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        kimlaurits 

        #Using AD Security group

        $Body = @{
        identifier= “<groupidfromAzureAD>” #Object ID for the Security group
        groupUserAccessRight= “Admin” #Permission for the group to the Workspace
        principalType= “Group” #The type of Principal(App, Group, User)
        }

        $BodyJSON=$Body | ConvertTo-Json
        Invoke-PowerBIRestMethod -Method post -Url “/groups/<workspaceIDpastehere>/users” -Body $BodyJSON #Workspace ID


        Cheers
        Mahak

         

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Did you tried the latest code I posted?