Question

In Power Query, you have an existing query named "SalesRaw" that connects to a SQL Server table and applies several cleanup steps. You need to create a second query that starts from the fully cleaned output of "SalesRaw" to build an aggregated summary table, and you want any future changes to the cleanup steps in "SalesRaw" to automatically flow into the new query. Which action should you take?

Accepted Answer

Right-click "SalesRaw" and select Reference to create the new query.

Answer

Right-click "SalesRaw" and select Duplicate to create the new query.

Answer

Copy the M code from "SalesRaw" into a new blank query.

Answer

Create a new connection to the same SQL Server table and repeat the cleanup steps.