Forum Discussion
taran42
2 years agoAdvocate I
Bulk Assign Workspace Capacity
Is there a way I can assign multiple workspaces to a capacity at one time? I have approximately users in multiple countries and I have capacities based on each country. I want to take all users from ...
- 2 years ago
Hi taran42
You can bulk assign the workpsaces.
- I would first get the capacity ID's. Get Capacities As Admin
https://learn.microsoft.com/en-us/rest/api/power-bi/admin/get-capacities-as-admin
take the specific Capacity ID you want to assign the workspaces to. - Then get the workpsace ID's and map to your excel document.
Groups GetGroupsAsAdmin
https://learn.microsoft.com/en-us/rest/api/power-bi/admin/groups-get-groups-as-admin - When you have the workspace ID's and specific Capacity to which you want to assign the workspaces, use the Admin - Capacities AssignWorkspacesToCapacity to assign the workspaces in bulk.
https://learn.microsoft.com/en-us/rest/api/power-bi/admin/capacities-assign-workspaces-to-capacity
replace the CapacityID and WorkspacesID's in the script below
{
"capacityMigrationAssignments": [
{
"targetCapacityObjectId": "CapacityID",
"workspacesToAssign": [
"WorkspaceID1"
,"WorkspaceID2"
,...
]
}
]
}
- I would first get the capacity ID's. Get Capacities As Admin
SaiTejaTalasila
2 years agoSuper User
Hi,
Hi,
Hi,
You can use activity logs (audit logs) and your company's employee table it contains office 365 profile details create a relationship between 2 tables or apply join (you can check with your tenant admin) to identify the maximum number of users from each country. From this, you can decide.