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

Join us at the 2025 Microsoft Fabric Community Conference. March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for $400 discount. Register now

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebFBC_Carousel

Fabric Monthly Update - February 2025

Check out the February 2025 Fabric update to learn about new features.

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.