Question

You are building a Power Query solution that connects to a large SQL Server table. You need three separate output queries: one filtered to the current year, one aggregated by region, and one containing only lookup columns. You want all three to share a single base connection so that connection settings and initial steps are defined only once, and changes to the base propagate to all three. Which approach should you use?

Accepted Answer

Create one base query pointing to the SQL Server table, then create three Reference queries from it and apply the specific steps to each reference.

Answer

Create one base query, then create three Duplicate queries from it and apply the specific steps to each duplicate.

Answer

Create three independent queries that each connect directly to the SQL Server table and add the required steps.

Answer

Create one query with all three transformations chained together and load it three times.