Reply
arpost
Kudo Collector
Kudo Collector

Help! How do you take over pipeline connections when a user leaves the org?

Greetings, community. We have a set of pipelines that were created by a specific user with connections under that user's account. That user is no longer with the org, and we are getting the following error:

 

Failed to load the connection. Please make sure it exists and you have the permissions to access it.

 

arpost_0-1733497911475.png

 

Does anyone know how we can reclaim these connections WITHOUT modifying them and/or saving copies of the pipelines?

 

1 ACCEPTED SOLUTION
NandanHegde
Super User
Super User

Sharing a connection :

NandanHegde_0-1733551181831.png

 

Then manage users :

NandanHegde_1-1733551256108.png

 

then select the user and the apt permission :

NandanHegde_2-1733551332782.png

 

 

So whenever a connection is created by a user, he/she should share that connection with other users.

 

In case if the connection is not shared, then a new connection has to be created for the job to execute back else it can be edited

 

 




----------------------------------------------------------------------------------------------
Nandan Hegde (MSFT Data MVP)
LinkedIn Profile : www.linkedin.com/in/nandan-hegde-4a195a66
GitHUB Profile : https://github.com/NandanHegde15
Twitter Profile : @nandan_hegde15
MSFT MVP Profile : https://mvp.microsoft.com/en-US/MVP/profile/8977819f-95fb-ed11-8f6d-000d3a560942
Topmate : https://topmate.io/nandan_hegde
Blog :https://datasharkx.wordpress.com

View solution in original post

4 REPLIES 4
FabianSchut
Super User
Super User

If this connection happens to be in a gateway where you are the owner of, you can use the Fabric api to add users to an existing connection. First, you will need to retrieve the connection id with the following request: https://learn.microsoft.com/en-us/rest/api/power-bi/gateways/get-datasources

then you will need to add yourself to the connection with the following request: https://learn.microsoft.com/en-us/rest/api/fabric/core/connections/add-connection-role-assignment?ta...

NandanHegde
Super User
Super User

Sharing a connection :

NandanHegde_0-1733551181831.png

 

Then manage users :

NandanHegde_1-1733551256108.png

 

then select the user and the apt permission :

NandanHegde_2-1733551332782.png

 

 

So whenever a connection is created by a user, he/she should share that connection with other users.

 

In case if the connection is not shared, then a new connection has to be created for the job to execute back else it can be edited

 

 




----------------------------------------------------------------------------------------------
Nandan Hegde (MSFT Data MVP)
LinkedIn Profile : www.linkedin.com/in/nandan-hegde-4a195a66
GitHUB Profile : https://github.com/NandanHegde15
Twitter Profile : @nandan_hegde15
MSFT MVP Profile : https://mvp.microsoft.com/en-US/MVP/profile/8977819f-95fb-ed11-8f6d-000d3a560942
Topmate : https://topmate.io/nandan_hegde
Blog :https://datasharkx.wordpress.com

Thanks for the replies, @FabianSchut and @NandanHegde.

 

@FabianSchut, this isn't through a gateway.

 

@NandanHegde, I'm guessing there's no way for an Admin to manage this at present? It has to be done via a user's account? That's what my research showed, but I was hoping I'd be proven wrong...

Unfortunately @arpost that is my undersatnding as well. There was a recent announcement w.r.t API release for connection which may or may not help use on automation of it (as I am yet to test it out)




----------------------------------------------------------------------------------------------
Nandan Hegde (MSFT Data MVP)
LinkedIn Profile : www.linkedin.com/in/nandan-hegde-4a195a66
GitHUB Profile : https://github.com/NandanHegde15
Twitter Profile : @nandan_hegde15
MSFT MVP Profile : https://mvp.microsoft.com/en-US/MVP/profile/8977819f-95fb-ed11-8f6d-000d3a560942
Topmate : https://topmate.io/nandan_hegde
Blog :https://datasharkx.wordpress.com
avatar user

Helpful resources

Announcements
MarchFBCvideo - carousel

Fabric Monthly Update - March 2025

Check out the March 2025 Fabric update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)