topic Re: How to change ownership of a pipeline in MS Fabric in Pipelines

How to change ownership of a pipeline in MS Fabric

Mat07 — Thu, 20 Jun 2024 13:33:25 GMT

Our organization uses MS Fabric to create data pipelines. My predecessor created one pipeline that is central to daily processing of data, however he has left the organization. Everything fell over recently when his access credentials were revoked. (naturally)

He actually set up the architecture in the workspace where the pipeline lives. He was responsible for setting up Fabric and did so using his account.

Our investigation shows that the pipeline he created was using his own account and classifies him as the owner. When his account access was revoked (for obvious reasons), that pipeline no longer had access to data and the data ingestion failed.

I even tired creating a pipeline myself and it gave me the following error:

I am unable to find anything online or in any documentation about how to transfer ownership to another account.

I am a workspace Admin so I have the right permissions to access the workspace and any objects in the workspace.

I am aware that ownership can be transfered to a service account; However, that would mean we loose our audit trail and that is important to us. There would be no way of telling who did what.

Is there a solution to help us get the functionality of the pipeline and the whole Fabric architecture while insuring an audit trail for the auditors?

We also whould want a solution that ensures that this does not happen again if someone else leaves.

Re: How to change ownership of a pipeline in MS Fabric

Anonymous — Fri, 21 Jun 2024 10:26:21 GMT

Hi Mat07 ,

Apologize for the issue you are facing. Inorder to change the ownership of the Data Pipeline

The best course of action is to open a support ticket and have our support team take a closer look at it.

Please reach out to our support team so they can do a more thorough investigation on why this it is happening: Link

After creating a Support ticket please provide the ticket number as it would help us to track for more information.

Hope this helps. Please let us know if you have any other queries.

Re: How to change ownership of a pipeline in MS Fabric

NandanHegde — Fri, 21 Jun 2024 11:35:50 GMT

Can you please clarify the below aspects:

1) What do you mean by I even tired creating a pipeline myself ? Do you use the Save As Functionality to clone the pipeline and run? Or copied the JSON and created a new pipeline?

2) By any chance, was the connection that was originally created shared with you?

Re: How to change ownership of a pipeline in MS Fabric

Mat07 — Sun, 23 Jun 2024 04:10:10 GMT

@NandanHedge sure I can clarify.

1) I created a new unrelated pipeline to test it. This one also failed.

2) The connection was not shared with me.

Re: How to change ownership of a pipeline in MS Fabric

Anonymous — Tue, 25 Jun 2024 09:57:55 GMT

Hi Mat07 ,

We haven’t heard from you on the last response and was just checking back to see if you got a chance to open a support ticket.
After creating a Support ticket please provide the ticket number as it would help us to track for more information.

Thanks

Re: How to change ownership of a pipeline in MS Fabric

vivien57 — Thu, 08 Aug 2024 07:31:44 GMT

Hello Mat07 ,

I find the subject important and unanswered. So I'd like to ask you if you've had any information on this subject.

Thank you in advance.

Have a nice day,

Vivien

Re: How to change ownership of a pipeline in MS Fabric

frithjof_v — Thu, 08 Aug 2024 16:49:22 GMT

Copy pasting this from another post. Please vote:

Here are some related Ideas regarding ownership of items (please vote/comment inside the Ideas page to highlight the need):

Here is a general Fabric idea related to transferring ownership of Fabric items: https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=4cb25a68-7d4d-ef11-b4ac-000d3a0e6066

An idea about transfer Lakehouse ownership: https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=c507598c-0f44-ef11-b4ad-000d3a02b6d0

Why not have option for multiple owners of an item? https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=0acce98c-7e4d-ef11-b4ac-000d3a0e6066

Or just let the Workspace own the items, so it's not related to a user account.

https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=1a2d3ce6-7d4d-ef11-b4ac-000d3a0e6066

Here is also an idea regarding ability to edit a shortcut's target path (just thought I'd throw that one in as well):

https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=c49f426c-8c4d-ef11-b4ac-000d3a0e6066

Re: How to change ownership of a pipeline in MS Fabric

NandanHegde — Fri, 09 Aug 2024 03:59:28 GMT

Unfortunately as of today there is no direct way to update the ownership of the data pipelines and the only solution to ensure the pipelines do not fail post disablement of the owner account is to :

modify the schedule/any other activity within the individual pipelines so that last modified user gets changed

Re: How to change ownership of a pipeline in MS Fabric

Jeanxyz — Fri, 18 Oct 2024 08:03:16 GMT

Do you have edit rights to the pipeline? Here is my try:

open the pipeline- make a copy of the pipeline using "Save As" button - open the copied pipeline, open each module and update the credentials in the setting page.

It works for me.

Re: How to change ownership of a pipeline in MS Fabric

acteon_jon_catt — Thu, 21 Nov 2024 11:43:08 GMT

Hi Nandan
I'd like to confirm what you're saying there is; that as long as the "Last modified by" user is a live/licenced account, the Pipeline will continue to run even when the "Owned by" user is a disabled/deleted account? Per my image below:

Re: How to change ownership of a pipeline in MS Fabric

Anonymous — Mon, 02 Dec 2024 19:00:47 GMT

here is support ticket id i have similar issue 2412020040008529

Re: How to change ownership of a pipeline in MS Fabric

vivien57 — Thu, 15 May 2025 12:49:58 GMT

Hello Mat07

It's available natively now

https://learn.microsoft.com/en-us/fabric/fundamentals/item-ownership-take-over

If it's ok for you, you can put a kudo and validate the solution 😉

Vivien

Re: How to change ownership of a pipeline in MS Fabric

acteon_jon_catt — Thu, 15 May 2025 13:25:12 GMT

Unfortunately, until Registered Apps/Service Principals are supported for this, then we're simply kicking the can down the road until the current user who took over control leaves. Until then, this issue remains unresolved.

Re: How to change ownership of a pipeline in MS Fabric

vivien57 — Thu, 15 May 2025 13:39:50 GMT

I don't really agree in the sense that it's now possible to take over the owership of Fabric elements via the interface (before it was laborious via API). It's true, though, that you need to have rights to the Workspace, but that's the whole point of having Fabric Admins in the company