How to Add/change Deployment Pipeline's Admin in Power BI if not have access due to limitation

[Anonymous]

#Deployment Pipeline #PowerBI #restAPI #Adminupdate 

Hi All,

We had a challenge in our project and surely you might get into the same situation so below are my findings and resolution which will be helpful.

Quick Info :

• We have “Deployment Pipelines” in PowerBI which is the best way to use Workspace and content of power bi as Test Dev and PROD. More Info : https://docs.microsoft.com/en-us/power-bi/create-reports/deployment-pipelines-overview
• 
• Currently, Deployment Pipeline has a Limitation where you cannot add/change the Pipeline assigned to the workspace if the user has not been given the rights on the pipeline.
• You should have Administrator Rights to run the Rest API for that workspace and azure directory ( Basically a Power BI Admin)

Problem :

• Someone assigned the Workspace to his/her pipeline and left the organization.
• Did not add any other user/group to access the pipeline as per the recommendations.
• There is no way you can Assign yourself or your group to Pipeline and fix it.

Resolution :

• Making changes in GUI is in the idea portal so need to wait for it.
• You can use RestAPI to fix the issue and add the user to the Admin of the Pipeline which should be there. Below is the process for the same.
  • I am using Powershell + PowerBI RestAPI for achieving the same.
  • Open Powershell and Connect Power BI
    • Connect-PowerBIServiceAccount
    • 
    • Get-PowerBIWorkspace -All
  • Run the command below to get all the Pipelines created in the Organization
    • Invoke-PowerBIRestMethod -url "https://api.powerbi.com/v1.0/myorg/admin/pipelines?$expand=stages&$top=100" -Method GET
    • 
  • #WithStages (Optional)
    • Invoke-PowerBIRestMethod -url "https://api.powerbi.com/v1.0/myorg/admin/pipelines?$expand=stages" -Method GET
  • #WithUSers (Optional)
    • Invoke-PowerBIRestMethod -url "https://api.powerbi.com/v1.0/myorg/admin/pipelines?$expand=users" -Method GET
  • Note : Note the ID of the Pipeline you wanted to make changes

• • #GetUserID and Body ( Add the user ID to be added to the Pipeline)
    • $body = '{

"identifier": "user-Mahak@company.onmicrosoft.com",

"accessRight": "Admin",

"principalType": "User"

}'

$content = 'application/json'

• • #Update Pipeline with Admin User.

• • • Invoke-PowerBIRestMethod -url "https://api.powerbi.com/v1.0/myorg/admin/pipelines/<pipeline-IDxxx-xxx-xxx-xxxx>/users" -Method POST -Body $body -ContentType $content
    • 

The Pipeline will be updated and you can now go to PowerBI > Deployment Pipeline > You will see the Pipeline where you made the changes.

Cheers,

M