March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe 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
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?
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:
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;
Scroll down page up to http box, click on [Try it], paste deployment pipeline id on pipelineId parameter.
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.
{
"identifier": "admin@yourdomain.com",
"accessRight": "Admin",
"principalType": "User"
}
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.
Solved! Go to Solution.
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.
Proud to be a Super User! | |
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.
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.
Proud to be a Super User! | |
User | Count |
---|---|
25 | |
21 | |
11 | |
10 | |
9 |
User | Count |
---|---|
48 | |
30 | |
18 | |
17 | |
15 |