View all Pipelines

[jasonsnc42]

I am an administrator of our Power BI service and I cannot view any pipelines created by other users. I can see that workspaces have pipelines, but I cannot find a setting or console where I can view or add myself rights to that pipeline even though I'm a Admin on our service.

The question is: How do I view or add rights to a pipeline that was created and owned by someone else? Also, is there a way I can view all pipelines in our service?

[lbendlin · Accepted solution]

Pipelines - Get Pipelines - REST API (Power BI Power BI REST APIs) | Microsoft Docs

Admin - Pipelines GetPipelinesAsAdmin - REST API (Power BI Power BI REST APIs) | Microsoft Docs

[LeeBenjamin]

Hi @jasonsnc42 
For your first question, I believe this documentation is relevant:
Deployment Pipeline - Update User As Admin 
BR,
Lee

[KarenL7]

I have question about this -

With the Admin Portal - we can see All the Workspaces - but we cannot see any of the deployment Pipelines

I would like to add myself as user/admin like I can in the workspaces in the admin portal.

In your answer you state I have to do this via an API.

Will the deployment pipelines be available via the Admin Portal the same as all workspaces? Thanks

[LeeBenjamin]

Hi @KarenL7 , This is an intresting idea which in order to sense its demand, appreciate it if you could post an idea for that on our Ideas portal to get some votes for that. Ideas portal
Thanks!

Lee

[lbendlin · Accepted solution]

Pipelines - Get Pipelines - REST API (Power BI Power BI REST APIs) | Microsoft Docs

Admin - Pipelines GetPipelinesAsAdmin - REST API (Power BI Power BI REST APIs) | Microsoft Docs

[Anonymous]

Thanks! what is cool is I could run the API from the link. This confirmed my suspicion that there are some deployment pipelines that I cannot see.  Now the million dollar question is how do I change who can access the deployment pipeline since I cannot reach the actual pipeline to manage access?

[lbendlin]

even with the second link?

[Anonymous · Accepted solution]

I finally got it to work.  No the second link just gets the pipelines.   I had pipelines that were actually assigned to no user. I suspect it was assigned to the manager before me and we she left the user went null.  To update the user is the secret and I tried to use the link above, from LeeBenjamin: Deployment Pipeline - Update User As Admin 

which used this API call.  POST https://api.powerbi.com/v1.0/myorg/admin/pipelines/{pipelineId}/users

The documentation may be incorrect, as I could not get it to work until I changed the body key "accessRight"  to "PipelineUserAccessRight".  I only figured that out because I was clued by a previous error message.   It was a lot of trial and error but problem finally solved! 

[samsonfrb]

In my case, I really needed to use "Admin" for "accessRight". If I use "PipelineUserAccessRight", I get an HTTP 400. The documentation mention "Admin" as the UI in the service.

function Grant-PipelineAccess {

    param (

        [string]$accessToken,

        [string]$pipelineGuid,

        [string]$groupId

    )

    $body = @{

        identifier = $groupId

        accessRight = "Admin"

        principalType = "Group"

    } | ConvertTo-Json

    $headers = @{

        "Authorization" = "Bearer $accessToken"

        "Content-Type" = "application/json"

    }

    Invoke-RestMethod -Uri "https://api.powerbi.com/v1.0/myorg/admin/pipelines/$pipelineGuid/users" -Method Post -Body $body -Headers $headers

}

Frederick

[fvalencia]

Sounds like the team needs to create a User Interface that would avoid users interacting with api's to do something simple such as granting access to a Deployment Pipeline. The same feature exists for workspaces BTW.