Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
kimlaurits
Frequent Visitor

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 to add a synchronised AD group as contributor, with the following:
Add-PowerBIWorkspaceUser -Id <ID of PowerBI Workspace> -PrincipalType Group -AccessRight Contributor -Identifier <Object Id of AD group>

I get the error:

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

 

Am I missing something - or doing it wrong?

 

 

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

HI , 
Below worked like a charm : 

mahakrathore_0-1654173532730.png

 

Add-PowerBIWorkspaceUser -Scope Organization -Id <workspaceid> -UserEmailAddress mahak@xxxxxxxxx.com -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


 

View solution in original post

10 REPLIES 10
Anonymous
Not applicable

Did you tried : 

Add-PowerBIWorkspaceUser -Scope Individual -Id myWorkSpaceIDasString -Identifier myIdentifierAsString -AccessRight Admin -PrincipalType Group

Regards,Mahak 

Anonymous
Not applicable

Also, there is a very nice blog/code available for Automation: https://github.com/microsoft/powerbi-powershell/blob/master/src/Modules/Workspaces/Commands.Workspac... which can help more. Tried and Tested.

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
Not applicable

HI , 
Below worked like a charm : 

mahakrathore_0-1654173532730.png

 

Add-PowerBIWorkspaceUser -Scope Organization -Id <workspaceid> -UserEmailAddress mahak@xxxxxxxxx.com -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


 

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

 

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

Anonymous
Not applicable

Did you tried the latest code I posted?

Anonymous
Not applicable

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
Not applicable

@kimlaurits 

mahakrathore_0-1654174373605.png

#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

 

Yes, that seems to work well.

 

Anonymous
Not applicable

Awesome. Could you please mark it as Solution Provided i.e. my answer. 

Cheers

Mahak

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors