{"id":2020,"date":"2026-09-16T08:28:32","date_gmt":"2026-09-16T08:28:32","guid":{"rendered":"https:\/\/entri.app\/explore\/?post_type=curriculum&#038;p=2020"},"modified":"2026-09-16T09:29:15","modified_gmt":"2026-09-16T09:29:15","slug":"introduction-to-merging-queries","status":"publish","type":"curriculum","link":"https:\/\/entri.app\/explore\/power-bi\/introduction-to-merging-queries\/","title":{"rendered":"Introduction to Merging Queries"},"content":{"rendered":"<h2>What Is Merge Queries in Power BI?<\/h2>\n<p>Merge Queries in Power BI combines columns from two or more tables into a single query by matching rows on a shared key column \u2014 similar to a SQL JOIN. It is performed inside Power Query Editor and lets you enrich a fact table with lookup data (e.g., adding product names to a sales table) without flattening your data model.<\/p>\n<h2>How Does Merge Queries Work in Power BI?<\/h2>\n<p>When you merge queries, Power Query matches rows from two tables based on one or more key columns you select. You choose a join kind \u2014 Inner, Left Outer, Right Outer, Full Outer, Left Anti, or Right Anti \u2014 which determines which rows are kept or discarded. The result is a new or modified query with an expandable column containing the matched rows from the second table.<\/p>\n<ul>\n<li>Select Home \u2192 Merge Queries (or Merge Queries as New to keep the originals unchanged).<\/li>\n<li>Pick the matching column(s) in both tables.<\/li>\n<li>Choose the join kind that fits your scenario.<\/li>\n<li>Expand or aggregate the new column to pull in the fields you need.<\/li>\n<\/ul>\n<h2>How to Merge Sheets in Power Query<\/h2>\n<p>You can merge sheets from the same or different Excel workbooks inside Power Query. First, load each sheet as a separate query using Get Data \u2192 Excel Workbook. Then use Home \u2192 Merge Queries, select the key column that both sheets share (e.g., Employee ID, Product Code), and choose a join kind. This works identically whether your source is Power BI Desktop or Excel&#8217;s own Power Query.<\/p>\n<h2>How to Merge Tables in Power Query<\/h2>\n<p>Merging tables follows the same steps as merging sheets \u2014 every data source loaded into Power Query is simply a &#8216;query&#8217; (table). The key requirement is a shared column with matching values. If the column names differ between tables, that is fine \u2014 Power Query matches on values, not names. After selecting the join columns and kind, expand the resulting nested table to bring specific columns into your output.<\/p>\n<h2>Power Query Merge Columns \u2014 Concatenating Text Columns<\/h2>\n<p>&#8216;Merge Columns&#8217; is a different feature from &#8216;Merge Queries.&#8217; It concatenates two or more text columns within the same table into a single column, using a separator you specify (e.g., space, comma, dash). Select the columns, right-click \u2192 Merge Columns, and choose the delimiter. The original columns are replaced by default \u2014 duplicate them first if you need to keep them.<\/p>\n<h2>Merge Queries Power BI: Join Kinds Explained<\/h2>\n<table style=\"height: 588px;\" width=\"930\">\n<tbody>\n<tr>\n<td width=\"250\"><strong><b>Join Kind<\/b><\/strong><\/td>\n<td width=\"250\"><strong><b>Rows Kept<\/b><\/strong><\/td>\n<td width=\"250\"><strong><b>Typical Use Case<\/b><\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"250\">Left Outer<\/td>\n<td width=\"250\">All rows from the first (left) table; matched rows from the second<\/td>\n<td width=\"250\">Enrich a fact table with dimension data, keeping all fact rows<\/td>\n<\/tr>\n<tr>\n<td width=\"250\">Right Outer<\/td>\n<td width=\"250\">All rows from the second (right) table; matched rows from the first<\/td>\n<td width=\"250\">Less common; same as Left Outer with tables swapped<\/td>\n<\/tr>\n<tr>\n<td width=\"250\">Full Outer<\/td>\n<td width=\"250\">All rows from both tables<\/td>\n<td width=\"250\">Reconciliation \u2014 find what exists in either or both<\/td>\n<\/tr>\n<tr>\n<td width=\"250\">Inner<\/td>\n<td width=\"250\">Only rows that match in both tables<\/td>\n<td width=\"250\">Show only records with complete data on both sides<\/td>\n<\/tr>\n<tr>\n<td width=\"250\">Left Anti<\/td>\n<td width=\"250\">Rows from the first table that have NO match in the second<\/td>\n<td width=\"250\">Find missing or orphaned records<\/td>\n<\/tr>\n<tr>\n<td width=\"250\">Right Anti<\/td>\n<td width=\"250\">Rows from the second table that have NO match in the first<\/td>\n<td width=\"250\">Same as Left Anti with tables swapped<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<h2>Merge Excel Files Power Query \u2014 Combining Multiple Workbooks<\/h2>\n<p>To merge multiple Excel files (e.g., monthly reports in a folder), use Get Data \u2192 Folder, point to the directory, then combine and transform. Power Query reads each file&#8217;s matching sheet and stacks\/merges them. For a key-based merge (not stacking), load each file as a separate query first, then use Merge Queries to join them on a shared key.<\/p>\n<h2>Power Query Merge Multiple Sheets in One Workbook<\/h2>\n<p>If your sheets live in a single workbook and share a key column, load each sheet as a query (Get Data \u2192 Excel Workbook \u2192 select multiple sheets). Then merge them pairwise or chain multiple merges. For stacking rows from identically structured sheets (no key-based join), use Append Queries instead \u2014 see the Appending Queries topic.<\/p>\n<table>\n<tbody>\n<tr>\n<td width=\"250\"><\/td>\n<td width=\"250\"><strong><b>Merge Queries<\/b><\/strong><\/td>\n<td width=\"250\"><strong><b>Append Queries<\/b><\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"250\">Purpose<\/td>\n<td width=\"250\">Combine columns from two tables using a key (SQL JOIN)<\/td>\n<td width=\"250\">Stack rows from two or more tables (SQL UNION ALL)<\/td>\n<\/tr>\n<tr>\n<td width=\"250\">Result shape<\/td>\n<td width=\"250\">Wider \u2014 more columns, same or fewer rows<\/td>\n<td width=\"250\">Taller \u2014 more rows, same columns<\/td>\n<\/tr>\n<tr>\n<td width=\"250\">Requires matching key?<\/td>\n<td width=\"250\">Yes \u2014 one or more shared key columns<\/td>\n<td width=\"250\">No \u2014 just matching column names\/types<\/td>\n<\/tr>\n<tr>\n<td width=\"250\">Analogy<\/td>\n<td width=\"250\">VLOOKUP \/ INDEX-MATCH across tables<\/td>\n<td width=\"250\">Copy-paste rows from one sheet below another<\/td>\n<\/tr>\n<tr>\n<td width=\"250\">When to use<\/td>\n<td width=\"250\">Enrich data (e.g., add product names to sales)<\/td>\n<td width=\"250\">Combine monthly\/regional tables with the same structure<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2>How to Merge Queries in Power BI \u2014 Step-by-Step Tutorial<\/h2>\n<p>This tutorial walks you through merging two tables in Power Query Editor using a Left Outer join, then expanding the result to pull in columns from the second table. You will complete the merge in about 5 steps and under 10 minutes.<\/p>\n<h3>Prerequisites<\/h3>\n<ul>\n<li>Power BI Desktop installed (free download from Microsoft Store).<\/li>\n<li>Two tables loaded into Power Query \u2014 e.g., a Sales table and a Products table sharing a Product ID column.<\/li>\n<\/ul>\n<h3>Steps<\/h3>\n<p><strong><b>Step 1: Open Power Query Editor<\/b><\/strong><\/p>\n<p>In Power BI Desktop, click Home \u2192 Transform Data to open Power Query Editor. You should see both queries listed in the Queries pane on the left.<\/p>\n<p><strong><b>Step 2: Select the primary query<\/b><\/strong><\/p>\n<p>Click on the query you want to add columns to (e.g., Sales). This will be the &#8216;left&#8217; table in the merge.<\/p>\n<p><strong><b>Step 3: Start the Merge<\/b><\/strong><\/p>\n<p>Click Home \u2192 Merge Queries. In the dialog, the top table is already your selected query. Use the bottom dropdown to pick the second table (e.g., Products).<\/p>\n<p><strong><b>Step 4: Select matching columns<\/b><\/strong><\/p>\n<p>Click the key column in the top table (e.g., Product ID), then click the same-named column in the bottom table. Both columns highlight in green when selected. Choose &#8216;Left Outer&#8217; as the join kind so all Sales rows are kept.<\/p>\n<p><strong><b>Step 5: Expand the merged column<\/b><\/strong><\/p>\n<p>After clicking OK, a new column appears (e.g., &#8216;Products&#8217;). Click the expand icon (double-arrow) in its header, uncheck &#8216;Use original column name as prefix&#8217; if you prefer clean names, select the columns to bring in (e.g., Product Name, Category), and click OK.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>What Is Merge Queries in Power BI? Merge Queries in Power BI combines columns from two or more tables into a single query by matching rows on a shared key column \u2014 similar to a SQL JOIN. It is performed inside Power Query Editor and lets you enrich a fact table with lookup data (e.g., [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"template":"","meta":{"_acf_changed":false},"curriculum-category":[91,132],"custom_linking_tags":[133],"class_list":["post-2020","curriculum","type-curriculum","status-publish","hentry","curriculum-category-power-bi-tutorials","curriculum-category-merging-queries","custom_linking_tags-merging-queries"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.0 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Introduction to Merging Queries - Entri Free Materials<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/entri.app\/explore\/power-bi\/introduction-to-merging-queries\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Introduction to Merging Queries - Entri Free Materials\" \/>\n<meta property=\"og:description\" content=\"What Is Merge Queries in Power BI? Merge Queries in Power BI combines columns from two or more tables into a single query by matching rows on a shared key column \u2014 similar to a SQL JOIN. It is performed inside Power Query Editor and lets you enrich a fact table with lookup data (e.g., [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/entri.app\/explore\/power-bi\/introduction-to-merging-queries\/\" \/>\n<meta property=\"og:site_name\" content=\"Entri Free Materials\" \/>\n<meta property=\"article:modified_time\" content=\"2026-09-16T09:29:15+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/entri.app\/explore\/power-bi\/introduction-to-merging-queries\/\",\"url\":\"https:\/\/entri.app\/explore\/power-bi\/introduction-to-merging-queries\/\",\"name\":\"Introduction to Merging Queries - Entri Free Materials\",\"isPartOf\":{\"@id\":\"https:\/\/entri.app\/explore\/#website\"},\"datePublished\":\"2026-09-16T08:28:32+00:00\",\"dateModified\":\"2026-09-16T09:29:15+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/entri.app\/explore\/power-bi\/introduction-to-merging-queries\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/entri.app\/explore\/power-bi\/introduction-to-merging-queries\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/entri.app\/explore\/power-bi\/introduction-to-merging-queries\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/entri.app\/explore\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Introduction to Merging Queries\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/entri.app\/explore\/#website\",\"url\":\"https:\/\/entri.app\/explore\/\",\"name\":\"Entri Free Materials\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/entri.app\/explore\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/entri.app\/explore\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/entri.app\/explore\/#organization\",\"name\":\"Entri Free Materials\",\"url\":\"https:\/\/entri.app\/explore\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/entri.app\/explore\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/wp-cdn.entri.app\/explore\/2025\/03\/logo.svg\",\"contentUrl\":\"https:\/\/wp-cdn.entri.app\/explore\/2025\/03\/logo.svg\",\"caption\":\"Entri Free Materials\"},\"image\":{\"@id\":\"https:\/\/entri.app\/explore\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Introduction to Merging Queries - Entri Free Materials","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/entri.app\/explore\/power-bi\/introduction-to-merging-queries\/","og_locale":"en_US","og_type":"article","og_title":"Introduction to Merging Queries - Entri Free Materials","og_description":"What Is Merge Queries in Power BI? Merge Queries in Power BI combines columns from two or more tables into a single query by matching rows on a shared key column \u2014 similar to a SQL JOIN. It is performed inside Power Query Editor and lets you enrich a fact table with lookup data (e.g., [&hellip;]","og_url":"https:\/\/entri.app\/explore\/power-bi\/introduction-to-merging-queries\/","og_site_name":"Entri Free Materials","article_modified_time":"2026-09-16T09:29:15+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/entri.app\/explore\/power-bi\/introduction-to-merging-queries\/","url":"https:\/\/entri.app\/explore\/power-bi\/introduction-to-merging-queries\/","name":"Introduction to Merging Queries - Entri Free Materials","isPartOf":{"@id":"https:\/\/entri.app\/explore\/#website"},"datePublished":"2026-09-16T08:28:32+00:00","dateModified":"2026-09-16T09:29:15+00:00","breadcrumb":{"@id":"https:\/\/entri.app\/explore\/power-bi\/introduction-to-merging-queries\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/entri.app\/explore\/power-bi\/introduction-to-merging-queries\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/entri.app\/explore\/power-bi\/introduction-to-merging-queries\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/entri.app\/explore\/"},{"@type":"ListItem","position":2,"name":"Introduction to Merging Queries"}]},{"@type":"WebSite","@id":"https:\/\/entri.app\/explore\/#website","url":"https:\/\/entri.app\/explore\/","name":"Entri Free Materials","description":"","publisher":{"@id":"https:\/\/entri.app\/explore\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/entri.app\/explore\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/entri.app\/explore\/#organization","name":"Entri Free Materials","url":"https:\/\/entri.app\/explore\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/entri.app\/explore\/#\/schema\/logo\/image\/","url":"https:\/\/wp-cdn.entri.app\/explore\/2025\/03\/logo.svg","contentUrl":"https:\/\/wp-cdn.entri.app\/explore\/2025\/03\/logo.svg","caption":"Entri Free Materials"},"image":{"@id":"https:\/\/entri.app\/explore\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/entri.app\/explore\/wp-json\/wp\/v2\/curriculum\/2020","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/entri.app\/explore\/wp-json\/wp\/v2\/curriculum"}],"about":[{"href":"https:\/\/entri.app\/explore\/wp-json\/wp\/v2\/types\/curriculum"}],"author":[{"embeddable":true,"href":"https:\/\/entri.app\/explore\/wp-json\/wp\/v2\/users\/2"}],"wp:attachment":[{"href":"https:\/\/entri.app\/explore\/wp-json\/wp\/v2\/media?parent=2020"}],"wp:term":[{"taxonomy":"curriculum-category","embeddable":true,"href":"https:\/\/entri.app\/explore\/wp-json\/wp\/v2\/curriculum-category?post=2020"},{"taxonomy":"custom_linking_tags","embeddable":true,"href":"https:\/\/entri.app\/explore\/wp-json\/wp\/v2\/custom_linking_tags?post=2020"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}