Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified as a Fabric Data Engineer: Check your eligibility for a 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700. Get started

Reply
ArjanFraaij
Frequent Visitor

Change user that runs the scheduled pipeline (SPN)

Hi All,

When you create a schedule this is using the current user context for the schedule. So when user X did create the schedule and this user is not longer member of our organization and his user account is inactive the schedule won't run anymore.
Giving a message like:

ArjanFraaij_0-1736331283126.png


How ever it's not possible to set a specific user for a schedule or change it after, or I can not find it 🙂

So do any of you know or it is posible to set a SPN as the executer of a schedule?

Regards,

Arjan

1 ACCEPTED SOLUTION
NandanHegde
Super User
Super User

Based on my understanding, as of today this is a limitaion wherein you cannot change the ownership directly.

You can either edit the trigger and save for it to work out or create a new trigger and delete the old one.

Also SPN support is yet not availabe at data pipeline or its API but the above idea is in backlog for next couple of months




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

1 REPLY 1
NandanHegde
Super User
Super User

Based on my understanding, as of today this is a limitaion wherein you cannot change the ownership directly.

You can either edit the trigger and save for it to work out or create a new trigger and delete the old one.

Also SPN support is yet not availabe at data pipeline or its API but the above idea is in backlog for next couple of months




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

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

JanFabricDE_carousel

Fabric Monthly Update - January 2025

Explore the power of Python Notebooks in Fabric!

JanFabricDW_carousel

Fabric Monthly Update - January 2025

Unlock the latest Fabric Data Warehouse upgrades!