topic Re: Help! How do you take over pipeline connections when a user leaves the org? in Pipelines

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

arpost — Fri, 06 Dec 2024 15:13:00 GMT

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?

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

NandanHegde — Sat, 07 Dec 2024 06:03:09 GMT

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

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

FabianSchut — Sat, 07 Dec 2024 08:59:32 GMT

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?tabs=HTTP

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

arpost — Thu, 12 Dec 2024 14:25:40 GMT

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

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

NandanHegde — Thu, 12 Dec 2024 14:49:15 GMT

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)