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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
hugosilvasilva
New Member

Define new admin to orphan deployment pipeline

If your deployment pipeline is orphan for whatever reasen (usually because the unique admin user has been deleted), there is a workaround as Administration Portal doens't provide any feature to deal with this situation.

 

This solution was provided by Microsoft support once I've faced this situation on my tenant and I decided to share it here as it may help others.

 

In order to run this tutorial, you must loggin with your Power BI global admin, ok?

 

  1. If you're already logged in Power BI and your user is not Power BI global admin, open new annonimous window;
  2. Go to https://learn.microsoft.com/en-us/rest/api/power-bi/admin/pipelines-get-pipelines-as-admin
  3. Scroll down the page up to first get script, click on [Try it], then sign in with your Power BI global admin; hugosilvasilva_0-1734088982430.png

     

  4. Once you sign in, click [Run >] at API script window. hugosilvasilva_2-1734089242456.png
  5. As response, all of your deployment pipelines will be listed in JSON format. Find your deployment pipeline by its name and copy its "id" value: 

    hugosilvasilva_3-1734089560121.png
  6. Now create new tab on same window (in order to use the same session of the user you're logged in) and open this page: https://learn.microsoft.com/en-us/rest/api/power-bi/admin/pipelines-update-user-as-admin;

  7. Scroll down page up to http box, click on [Try it], paste deployment pipeline id on pipelineId parameter. 

    hugosilvasilva_4-1734089992776.png
  8. At body text area box, paste the following code replacing "admin@yourdomain.com" by the user you wish to be the new deployment pipeline admin.

  9.  

 

 

{
  "identifier": "admin@yourdomain.com",
  "accessRight": "Admin",
  "principalType": "User"
}​

 

hugosilvasilva_5-1734090073806.png

 

  • Click [Run] and as response you must be prompt to code 200. It must suffice.

    Ask user to check if now he can access deployment pipeline as admin.

     

 

That's it. Hope it helps. 

1 ACCEPTED SOLUTION
rajendraongole1
Super User
Super User

Hi @hugosilvasilva -Yes, the process you've outlined to recover orphaned deployment pipelines in Power BI is a solution that uses Power BI REST APIs. 

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

Admin - Pipelines UpdateUserAsAdmin - REST API (Power BI Power BI REST APIs) | Microsoft Learn

Use the "Get Pipelines as Admin" API to find the orphaned pipeline's ID.
Use the "Update Pipeline User as Admin" API to reassign an admin to the pipeline.
Verify the changes in the Power BI Service.
This workaround is particularly useful in situations where the previous admin has been deleted, and no other user has access to the deployment pipeline.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





View solution in original post

3 REPLIES 3
v-yaningy-msft
Community Support
Community Support

Hi, @hugosilvasilva 

Thanks for the sharing, you can copy and paste the shared content into the comment section and mark it as a solution so that people with similar problems can find the answer faster if they have a similar problem, thanks for your understanding.

Best Regards,
Yang

Community Support Team

For solution, proceed as described on main post.

rajendraongole1
Super User
Super User

Hi @hugosilvasilva -Yes, the process you've outlined to recover orphaned deployment pipelines in Power BI is a solution that uses Power BI REST APIs. 

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

Admin - Pipelines UpdateUserAsAdmin - REST API (Power BI Power BI REST APIs) | Microsoft Learn

Use the "Get Pipelines as Admin" API to find the orphaned pipeline's ID.
Use the "Update Pipeline User as Admin" API to reassign an admin to the pipeline.
Verify the changes in the Power BI Service.
This workaround is particularly useful in situations where the previous admin has been deleted, and no other user has access to the deployment pipeline.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





Helpful resources

Announcements
ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.