Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Anonymous

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

#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
  • mahakrathore_0-1654265617221.jpeg

     

  • 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 :

 

    • #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.

 

 

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

mahakrathore_4-1654265617226.jpeg

 

Cheers,

M

signatureForum.jpg

Comments