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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
TestCICD
Frequent Visitor

Unable to add groups to a workspace using Rest API

l need to use powershell to add a group to an existing workspace

 

Invoke-RestMethod -Method POST -Uri "https://api.powerbi.com/v1.0/myorg/groups/<groupId>/users" -Header @{Authorization = 'Bearer $token'; 'Content-type' = 'application/json'; 'User-Agent' = 'Jenkins'} -Body '{"principalType" = "Group", "groupUserAccessRight"= "Admin", "identifier"= "ID", "displayName"="MyGroupName"}'

 

I keep getting (400) Bad Request error. I am able to add individual users with this body:

{"groupUserAccessRight"= "Admin", "emailAddress"= "john@microsoft.com"}

 

 

What am I doing wrong to add groups?

 

EDIT: The problem seem to be the identifier number I am using. I am not sure how to retrieve the proper one though

1 ACCEPTED SOLUTION
v-jianboli-msft
Community Support
Community Support

Hi @TestCICD ,

 

With PowerShell, you can add an AD group to Power BI Workspace using the Groups – Add Group User API or Add-PowerBIWorkspaceUser Cmdlet.

What you will need:

  • Object ID for the group
    • From Azure Active Directory -> Select Groups -> Select the required Group -> Copy the Object ID
  • Access right to the Workspace for the group
    • Level of Access you want to grant to the Workspace (
      Member, Admin, Contributor, Viewer )
  • The PrincipalType
    • The type of Principal you want to add (
      App, Group, User ) For this example, we want to add an AD Security Group, so we will use Group
  • The Workspace ID
    • From Power BI Service -> Select the Workspace -> copy the ID next to Group in the URL.

For more details, please refer to:

ADDING AZURE AD SECURITY GROUP TO POWER BI WORKSPACE USING POWERSHELL - Ruki&#039;s Blog

Power BI Group management using Active Directory roles and PowerShell 

 

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

View solution in original post

2 REPLIES 2
v-jianboli-msft
Community Support
Community Support

Hi @TestCICD ,

 

With PowerShell, you can add an AD group to Power BI Workspace using the Groups – Add Group User API or Add-PowerBIWorkspaceUser Cmdlet.

What you will need:

  • Object ID for the group
    • From Azure Active Directory -> Select Groups -> Select the required Group -> Copy the Object ID
  • Access right to the Workspace for the group
    • Level of Access you want to grant to the Workspace (
      Member, Admin, Contributor, Viewer )
  • The PrincipalType
    • The type of Principal you want to add (
      App, Group, User ) For this example, we want to add an AD Security Group, so we will use Group
  • The Workspace ID
    • From Power BI Service -> Select the Workspace -> copy the ID next to Group in the URL.

For more details, please refer to:

ADDING AZURE AD SECURITY GROUP TO POWER BI WORKSPACE USING POWERSHELL - Ruki&#039;s Blog

Power BI Group management using Active Directory roles and PowerShell 

 

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

lbendlin
Super User
Super User

The groups need to be mail enabled AD groups.  The ID is  the AD GUID of the group.

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.