The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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:
Pipeline 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.
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
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.
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
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.
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
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
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:
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
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?
@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.
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.
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
here is support ticket id i have similar issue 2412020040008529
User | Count |
---|---|
3 | |
2 | |
2 | |
1 | |
1 |
User | Count |
---|---|
5 | |
4 | |
3 | |
2 | |
2 |