Get Workspace By Capacity Name

[paritoshmishra]

Is any way or rest API to get Workspace list by Capacity Name attached ..

TIA 

Paritosh Mishra 

[lbendlin · Accepted solution]

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

[lbendlin · Accepted solution]

# 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

[lbendlin]

Did you mean Postmates?

As far as I can see the response is identical.

[paritoshmishra]

Sorry for typo   mistakes.I have edited my previous msg  

[lbendlin · Accepted solution]

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

[paritoshmishra]

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"