Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,624 questions
Azure ADF Power Query (Preview)
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(278.4, 66%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJL%3C/text%3E%3C/svg%3E)
Jorge L Dominguez
51
Reputation points
I use the new Power Query (Preview) in the following pipeline. In "Debug" mode, it works as expected. However, when I execute the pipeline via trigger, it Skips the power query step.
Execution via Trigger:
Error message:
DetailsThe execution of template action 'MainPwQryFreight' is skipped: the 'runAfter' condition for action 'ExecuteMappingResolvedPwQryFreight' is not satisfied. Expected status values 'Succeeded' and actual value 'Failed'.
Anybody else experienced the same thing, and how did you overcome the issue?
Azure Data Factory
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(172.8, 70%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
MartinJaffer-MSFT 26,236 Reputation points2021-06-01T17:06:22.473+00:00 Hello @Jorge L Dominguez and welcome to Microsoft Q&A.
The error message you see refers to the connection between activities (dependencies). From your screenshot it looks like the skipped activity "MainPwQryFreight" is the first activity in the pipeline. As the first activity in the pipeline, we should not be seeing this message, so something is weird.
If you just want to get passed this and move on, try placing a Wait Activity in front of this activity, connected by green on-success dependency. I expect this would fix any dependency strangeness.
For a deeper investigation, I would need to first look at the pipeline JSON around this activity.
-
Jorge L Dominguez 51 Reputation points
2021-06-01T22:39:10.917+00:00 Hi MartinJaffer-MSFT
I have tried doing that; as you can appreciate from the screenshot below, it's interesting how it loses the integration runtime via a trigger?
I tried the same functionality using Dataflow with success:
Here is what I think is happening:
The Power Query (Preview) asset can not spin an Apache Spark cluster via the trigger engine. It works in debug mode because I manually spin the data bricks cluster from the "Data Flow Debug" button.When submitted to the trigger, it loses its Integration Runtime.
The question where to from here?
-
MartinJaffer-MSFT 26,236 Reputation points
2021-06-02T22:24:49.95+00:00 Ouch, that is some odd behavior.
I haven't used Power Query in a long time, so I'll try a simple one and check whether mine says Unknown runtime or not.
I have not found any similar cases or resources for this particular situation. I expect this will require deeper investigation than I can give over the forums. Have you opened a support ticket about this issue? If so, can you share the ticket number, if not I can help you get one.
-
Jorge L Dominguez 51 Reputation points
2021-06-02T23:10:00.51+00:00 Hi MartinJaffer-MSFT,
I have not raised a support ticket, and I have no clue how to raise a ticket. If you can point me in the right direction, I'll do it.
Regards
George -
MartinJaffer-MSFT 26,236 Reputation points
2021-06-16T00:08:40.773+00:00 @Jorge L Dominguez I haven't heard back from you or received email, so I will assume you either opened a ticket or found a solution.
Sign in to comment
Sign in to answer