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

[arpost]

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.

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

[FabianSchut]

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 · Accepted solution]

Sharing a connection :

Then manage users :

then select the user and the apt permission :

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

[arpost]

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

[NandanHegde]

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)