run_if condition to handle prior task excluded?

ChristianRRL
Honored Contributor

‎05-05-2026 12:29 PM

Hi there, I kind of know the answer here but want to check in case I'm missing anything (or else maybe vent slightly and hope for new functionality in the future).

Basically, I'm looking for a way to run a task if either (A) the prior step ran successfully, or (B) the prior step was excluded. However, based on available documentation, this doesn't seem to be possible because:

Here is an example highlighting this. As per the documentation, regardless of which run_if condition I use (All succeeded, At least one succeeded, None Failed, All done), because the prior step is excluded the following step is also excluded:

ChristianRRL_1-1778008957285.png

This leads me to the following configuration because existing functionality doesn't seem to support the simpler behavior I'm looking for: 

ChristianRRL_2-1778009198388.png

Let me know if I'm missing anything, or is there really no way to a task if the prior task has been excluded? If so, can I request for this functionality to be added in the future?

amirabedhiafi
Contributor

‎05-05-2026 01:51 PM

Hello @ChristianRRL  !

You are totally righy. With the current DBKS dependency semantics, a downstream task cannot run when all of its direct upstream dependencies are excluded regardless of the run_if option. If you check the doc it explicitly says (I am quoting here) "if all task dependencies are excluded, the task is also excluded, regardless of its run if condition." It also says excluded upstream tasks are treated as successful only when evaluating run_if but that rule does not help when all dependencies are excluded.

IMHO, your workaround is correct and you can add a second upstream dependency that is not excluded for example the condition task like Should_Run_Silver.

However, I would suggest using None failed instead of At least one succeeded for the curated tasks.

Why ? because if silver succeeds  the curated runs and if it is excluded but Should_Run_Silver succeeded you will also have curated running and if silver fails the curated does not run.

With At least one succeeded, the curated task could still run even if the silver task failed because Should_Run_Silver succeeded.is common branching pattern.

If this answer resolves your question, could you please mark it as “Accept as Solution”? It will help other users quickly find the correct fix.

Senior BI/Data Engineer | Microsoft MVP Data Platform | Microsoft MVP Power BI | Power BI Super User | C# Corner MVP

View solution in original post

ChristianRRL
Honored Contributor
In response to amirabedhiafi

‎05-06-2026 11:46 AM

Thank you for confirming. Also I really appreciate the added feedback to add `None failed`. This is super useful!

0 Kudos