A Power Query join that combines two queries on columns whose values match, using a join type you pick, much as SQL does. Plain Merge queries adds the join to the current query; the 'as new' variant produces a separate query.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains Merge queries in context, with comparison tables and the common traps.
Terms in this definition
- JOIN
Combines rows from two or more tables in one SELECT, most often by pairing a primary key with the foreign key that refers to it.
- VALUES
Returns in DAX the distinct column values, or table rows, still visible after filters are applied, sometimes with an extra blank entry. CALCULATE often takes the result as a table filter.
- MATCH
Used in WHERE when querying SQL Graph, it describes how to walk from node to node through edge tables, with patterns written like p1-(f1)->p2.
- Serverless
Compute tier for single Azure SQL databases that scales automatically, pauses when idle and charges by the second. It is offered in General Purpose and Hyperscale, not Business Critical, and reserved capacity does not apply.
- VARIANT
A type for semi-structured data like JSON whose structure isn't fixed, available from Databricks Runtime 15.4. It is preferred to storing JSON as strings but can't serve as a partition column.
Related terms
- Table.NestedJoin
Merge queries relies on this M function, which matches rows across two tables by their keys and nests the matches in a new column you can expand. Supported join kinds cover inner, outer, anti and semi joins, though the Merge dialog omits the LeftSemi and RightSemi options.