Forum Discussion
Get Workspace By Capacity Name
Is any way or rest API to get Workspace list by Capacity Name attached ..
TIA
Paritosh Mishra
Capacity names are meaningless. Depending on your tenant admin rights you can either see all workspaces, or you can see the workspaces that you are a member of.
Groups - Get Groups (Power BI Power BI REST APIs) | Microsoft Docs
# Calls the Active Directory Authentication Library (ADAL) to authenticate against AAD function GetAuthToken { if(-not (Get-Module AzureRm.Profile)) { Import-Module AzureRm.Profile } $clientId = "your client id here" $redirectUri = "urn:ietf:wg:oauth:2.0:oob" $resourceAppIdURI = "https://analysis.windows.net/powerbi/api" $authority = "https://login.microsoftonline.com/common/oauth2/authorize"; $authContext = New-Object "Microsoft.IdentityModel.Clients.ActiveDirectory.AuthenticationContext" -ArgumentList $authority $authResult = $authContext.AcquireToken($resourceAppIdURI, $clientId, $redirectUri, "Auto") return $authResult } # Get the auth token from AAD $token = GetAuthToken # Building Rest API header with authorization token $authHeader = @{ 'Content-Type'='application/json' 'Authorization'=$token.CreateAuthorizationHeader() } # get workspaces with capacityId where present $uri = "https://api.powerbi.com/v1.0/myorg/groups" $v = (Invoke-RestMethod -Uri $uri –Headers $authHeader –Method GET).value $v | Select id,isReadOnly,isOnDedicatedCapacity,capacityId,name | Format-Table -AutoSize
5 Replies
- lbendlinSuper User
Capacity names are meaningless. Depending on your tenant admin rights you can either see all workspaces, or you can see the workspaces that you are a member of.
Groups - Get Groups (Power BI Power BI REST APIs) | Microsoft Docs
- paritoshmishraHelper I
When this API "GET https://api.powerbi.com/v1.0/myorg/groups" runs by powershell its return 4 filed
id isReadOnly isOnDedicatedCapacity name
-- ---------- --------------------- ----
5bbca568-2881-4628-a28a-1d2245aea88c False False PowerbiAccessGroup
5e68fde1-5a6b-467b-af41-9775cc32166e False True condecouserdevt011
When same API on "Postman" its resposd body is{"@odata.context": "http://wabi-us-central-a-primary-redirect.analysis.windows.net/v1.0/myorg/$metadata#groups","@odata.count": 16,"value": [{"id": "5bbca568-2881-4628-a28a-1d2245aea88c","isReadOnly": false,"isOnDedicatedCapacity": false,"name": "PowerbiAccessGroup"},{"id": "5e68fde1-5a6b-467b-af41-9775cc32166e","isReadOnly": false,"isOnDedicatedCapacity": true,"capacityId": "D42A91A3-6A85-4290-8291-6ECFEC4BAC2B","name": "condecouserdevt011"}]
}This show "Capacity Id" field .How come ??/
How I get same response on powershell , as I run powershell on our pipeline >>>>
Its Postman .Postman response have capacityID where as powershell show only "id isReadOnly isOnDedicatedCapacity name"
- lbendlinSuper User
# Calls the Active Directory Authentication Library (ADAL) to authenticate against AAD function GetAuthToken { if(-not (Get-Module AzureRm.Profile)) { Import-Module AzureRm.Profile } $clientId = "your client id here" $redirectUri = "urn:ietf:wg:oauth:2.0:oob" $resourceAppIdURI = "https://analysis.windows.net/powerbi/api" $authority = "https://login.microsoftonline.com/common/oauth2/authorize"; $authContext = New-Object "Microsoft.IdentityModel.Clients.ActiveDirectory.AuthenticationContext" -ArgumentList $authority $authResult = $authContext.AcquireToken($resourceAppIdURI, $clientId, $redirectUri, "Auto") return $authResult } # Get the auth token from AAD $token = GetAuthToken # Building Rest API header with authorization token $authHeader = @{ 'Content-Type'='application/json' 'Authorization'=$token.CreateAuthorizationHeader() } # get workspaces with capacityId where present $uri = "https://api.powerbi.com/v1.0/myorg/groups" $v = (Invoke-RestMethod -Uri $uri –Headers $authHeader –Method GET).value $v | Select id,isReadOnly,isOnDedicatedCapacity,capacityId,name | Format-Table -AutoSize - lbendlinSuper User
Did you mean Postmates?
As far as I can see the response is identical.
- paritoshmishraHelper I
Sorry for typo mistakes.I have edited my previous msg