Which engine processes the added custom step in a dataflow?

Which engine processes the added custom step in a dataflow?

• A. Microsoft Power Query engine
• B. Microsoft Power BI Desktop
• C. M engine
• D. SQL engine

Answer: (A)

The step added in a dataflow is executed by the Power Query engine. Dataflows use Power Query to define transformations with the M language, and the Power Query engine runs that M code to apply each step, including any custom one. Power BI Desktop is just the authoring client, and SQL engine handles SQL queries—neither is responsible for processing the M-based dataflow steps. The M language defines what the step does, but the actual processing is done by the Power Query engine.

The step added in a dataflow is executed by the Power Query engine. Dataflows use Power Query to define transformations with the M language, and the Power Query engine runs that M code to apply each step, including any custom one. Power BI Desktop is just the authoring client, and SQL engine handles SQL queries—neither is responsible for processing the M-based dataflow steps. The M language defines what the step does, but the actual processing is done by the Power Query engine.