Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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?
Solved! Go to Solution.
HI ,
Below worked like a charm :
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
Did you tried :
Add-PowerBIWorkspaceUser -Scope Individual -Id myWorkSpaceIDasString -Identifier myIdentifierAsString -AccessRight Admin -PrincipalType Group
Regards,Mahak
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
HI ,
Below worked like a charm :
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.
Did you tried the latest code I posted?
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
#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.
Awesome. Could you please mark it as Solution Provided i.e. my answer.
Cheers
Mahak
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.