Append Multiple Tables Dynamically in Power Query M

Combines every query name in a list into one table, useful when the set of source tables can change.

Merging & AppendingAdvancedappendcombinedynamicunion

Power Query M code

let
    TableNames = {"Sales_Jan", "Sales_Feb", "Sales_Mar"},
    Tables = List.Transform(TableNames, each Expression.Evaluate(_, #shared)),
    Combined = Table.Combine(Tables)
in
    Combined

Notes

TableNames must exactly match the names of existing queries in this file. Expression.Evaluate resolves a query by name at runtime; keep the list of names trusted and under your own control.

Requirements

Several existing queries with the same column structure.

How to use this snippet

In Power BI Desktop, choose Transform data to open Power Query, then open the Advanced Editor on a query (or start from a blank query).
Paste the snippet and replace the placeholder names (tables, columns, file paths) with your own. Check the requirements above first.
Run it through the Power Query M Formatter to tidy the layout.

Related Power Query M snippets

More Power Query M resources

Browse all 145 snippets in the Power Query M Code Snippets, or search the library for something similar to Append Multiple Tables Dynamically.