{"id":85262,"date":"2022-09-16T16:33:21","date_gmt":"2022-09-16T14:33:21","guid":{"rendered":"https:\/\/rmarketingdigital.com\/powerbi\/combinar-varias-tablas-en-power-bi\/"},"modified":"2020-09-17T23:09:38","modified_gmt":"2020-09-18T02:09:38","slug":"combinar-varias-tablas-en-power-bi","status":"publish","type":"post","link":"https:\/\/rmarketingdigital.com\/en\/powerbi\/combinar-varias-tablas-en-power-bi\/","title":{"rendered":"Merge multiple tables in Power BI"},"content":{"rendered":"<div>\n<p>Merge Multiple Tables in Power BI: In real time, your data is in a normalized format, but in some situations, you may need the data denormalized. In this situation, you can join those tables with a query editor. Let me show you how to combine multiple tables in Power BI with an example.<\/p>\n<p><span id=\"ezoic-pub-ad-placeholder-104\"\/><span style=\"display:block !important;float:none !important;margin-bottom:15px !important;margin-left:0px !important;margin-right:0px !important;margin-top:15px !important;min-height:90px;min-width:728px;text-align:center !important;\" class=\"ezoic-ad medrectangle-3 adtester-container adtester-container-104\" data-ez-name=\"tutorialgateway_org-medrectangle-3\"><span id=\"div-gpt-ad-tutorialgateway_org-medrectangle-3-0\" ezaw=\"728\" ezah=\"90\" style=\"position:relative;z-index:0;display:inline-block;width:100%;max-width:1200px;margin-left:auto !important;margin-right:auto !important;min-height:90px;min-width:728px;\" class=\"ezoic-ad ezoic-adl\"\/><\/span><\/p>\n<h2>How to combine multiple tables in Power BI<\/h2>\n<p>In the screenshot below, you can see that there are three tables Product Category, Product Subcategory, and Product Table. We imported these tables in the Connect to SQL article.<\/p>\n<p>For the demonstration purpose of Combining Multiple Tables in Power BI, we are going to combine these three tables. To do so, click on the <b>Edit queries<\/b> option in Power BI <b>Home<\/b> tongue.<span id=\"ezoic-pub-ad-placeholder-132\" class=\"ezoic-adpicker-ad\"\/><span style=\"display:block !important;float:none !important;margin-bottom:15px !important;margin-left:0px !important;margin-right:0px !important;margin-top:15px !important;min-height:250px;min-width:300px;text-align:center !important;\" class=\"ezoic-ad box-3 adtester-container adtester-container-132\" data-ez-name=\"tutorialgateway_org-box-3\"><span id=\"div-gpt-ad-tutorialgateway_org-box-3-0\" ezaw=\"300\" ezah=\"250\" style=\"position:relative;z-index:0;display:inline-block;min-height:250px;min-width:300px;\" class=\"ezoic-ad ezoic-adl\"\/><\/span><\/p>\n<figure class=\"wp-block-image\"><img alt='combine-multiple-tables-in-power-bi-1-1253889' width='1090' height='690' class=\"wp-image-31030\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-1-1253889.png 1090w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-1-1253889-300x190.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-1-1253889-1024x648.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-1-1253889-768x486.png 768w' data-lazy-sizes='(max-width: 1090px) 100vw, 1090px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-1-1253889.png'\/><noscript><img alt='combine-multiple-tables-in-power-bi-1-1253889' width='1090' height='690' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-1-1253889.png' class=\"wp-image-31030\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-1-1253889.png 1090w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-1-1253889-300x190.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-1-1253889-1024x648.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-1-1253889-768x486.png 768w' sizes='(max-width: 1090px) 100vw, 1090px'\/><\/noscript><\/figure>\n<p>Clicking <b>Edit queries<\/b> The option opens a new window called <b>Power Query Editor<\/b>.<\/p>\n<p>In the following screenshot, you can see that the Product Subcategory table has a connection to the Product and Product Category table.<\/p>\n<p><span id=\"ezoic-pub-ad-placeholder-105\"\/><span style=\"display:block !important;float:none !important;margin-bottom:15px !important;margin-left:0px !important;margin-right:0px !important;margin-top:15px !important;min-height:400px;min-width:580px;text-align:center !important;\" class=\"ezoic-ad box-4 adtester-container adtester-container-105\" data-ez-name=\"tutorialgateway_org-box-4\"><span id=\"div-gpt-ad-tutorialgateway_org-box-4-0\" ezaw=\"580\" ezah=\"400\" style=\"position:relative;z-index:0;display:inline-block;width:100%;max-width:1200px;margin-left:auto !important;margin-right:auto !important;min-height:400px;min-width:580px;\" class=\"ezoic-ad ezoic-adl\"\/><\/span><\/p>\n<figure class=\"wp-block-image\"><img alt='combine-multiple-tables-in-power-bi-2-4722759' width='1241' height='707' class=\"wp-image-31031\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-2-4722759.png 1241w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-2-4722759-300x171.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-2-4722759-1024x583.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-2-4722759-768x438.png 768w' data-lazy-sizes='(max-width: 1241px) 100vw, 1241px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-2-4722759.png'\/><noscript><img alt='combine-multiple-tables-in-power-bi-2-4722759' width='1241' height='707' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-2-4722759.png' class=\"wp-image-31031\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-2-4722759.png 1241w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-2-4722759-300x171.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-2-4722759-1024x583.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-2-4722759-768x438.png 768w' sizes='(max-width: 1241px) 100vw, 1241px'\/><\/noscript><\/figure>\n<p>Before I start combining multiple tables in Power BI, let me duplicate this table by right-clicking on the table and selecting the Duplicate option from the context menu.<\/p>\n<figure class=\"wp-block-image\"><img alt='combine-multiple-tables-in-power-bi-3-6714500' width='1242' height='707' class=\"wp-image-31032\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-3-6714500.png 1242w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-3-6714500-300x171.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-3-6714500-1024x583.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-3-6714500-768x437.png 768w' data-lazy-sizes='(max-width: 1242px) 100vw, 1242px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-3-6714500.png'\/><noscript><img alt='combine-multiple-tables-in-power-bi-3-6714500' width='1242' height='707' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-3-6714500.png' class=\"wp-image-31032\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-3-6714500.png 1242w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-3-6714500-300x171.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-3-6714500-1024x583.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-3-6714500-768x437.png 768w' sizes='(max-width: 1242px) 100vw, 1242px'\/><\/noscript><\/figure>\n<p>We change its name Product information<\/p>\n<figure class=\"wp-block-image\"><img alt='combine-multiple-tables-in-power-bi-4-8906873' width='1241' height='709' class=\"wp-image-31033\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-4-8906873.png 1241w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-4-8906873-300x171.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-4-8906873-1024x585.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-4-8906873-768x439.png 768w' data-lazy-sizes='(max-width: 1241px) 100vw, 1241px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-4-8906873.png'\/><noscript><img alt='combine-multiple-tables-in-power-bi-4-8906873' width='1241' height='709' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-4-8906873.png' class=\"wp-image-31033\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-4-8906873.png 1241w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-4-8906873-300x171.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-4-8906873-1024x585.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-4-8906873-768x439.png 768w' sizes='(max-width: 1241px) 100vw, 1241px'\/><\/noscript><\/figure>\n<p>Click on the table in any row to display the information for the respective table.<\/p>\n<figure class=\"wp-block-image\"><img alt='combine-multiple-tables-in-power-bi-5-8131144' width='1274' height='733' class=\"wp-image-31034\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-5-8131144.png 1274w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-5-8131144-300x173.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-5-8131144-1024x589.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-5-8131144-768x442.png 768w' data-lazy-sizes='(max-width: 1274px) 100vw, 1274px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-5-8131144.png'\/><noscript><img alt='combine-multiple-tables-in-power-bi-5-8131144' width='1274' height='733' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-5-8131144.png' class=\"wp-image-31034\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-5-8131144.png 1274w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-5-8131144-300x173.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-5-8131144-1024x589.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-5-8131144-768x442.png 768w' sizes='(max-width: 1274px) 100vw, 1274px'\/><\/noscript><\/figure>\n<p>To merge the Dim Product table, click the right corner of the Dim Product column header. Open the following window. Use this window to select the required fields from the product table.<\/p>\n<figure class=\"wp-block-image\"><img alt='combine-multiple-tables-in-power-bi-6-1303312' width='1273' height='733' class=\"wp-image-31035\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-6-1303312.png 1273w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-6-1303312-300x173.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-6-1303312-1024x590.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-6-1303312-768x442.png 768w' data-lazy-sizes='(max-width: 1273px) 100vw, 1273px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-6-1303312.png'\/><noscript><img alt='combine-multiple-tables-in-power-bi-6-1303312' width='1273' height='733' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-6-1303312.png' class=\"wp-image-31035\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-6-1303312.png 1273w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-6-1303312-300x173.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-6-1303312-1024x590.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-6-1303312-768x442.png 768w' sizes='(max-width: 1273px) 100vw, 1273px'\/><\/noscript><\/figure>\n<p>We select the product key, product name, color and standard cost from the product table.<\/p>\n<figure class=\"wp-block-image\"><img alt='combine-multiple-tables-in-power-bi-7-6358590' width='1274' height='734' class=\"wp-image-31036\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-7-6358590.png 1274w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-7-6358590-300x173.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-7-6358590-1024x590.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-7-6358590-768x442.png 768w' data-lazy-sizes='(max-width: 1274px) 100vw, 1274px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-7-6358590.png'\/><noscript><img alt='combine-multiple-tables-in-power-bi-7-6358590' width='1274' height='734' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-7-6358590.png' class=\"wp-image-31036\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-7-6358590.png 1274w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-7-6358590-300x173.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-7-6358590-1024x590.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-7-6358590-768x442.png 768w' sizes='(max-width: 1274px) 100vw, 1274px'\/><\/noscript><\/figure>\n<p>Now you can see those columns within the product information table.<\/p>\n<figure class=\"wp-block-image\"><img alt='combine-multiple-tables-in-power-bi-8-9385530' width='1274' height='735' class=\"wp-image-31037\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-8-9385530.png 1274w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-8-9385530-300x173.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-8-9385530-1024x591.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-8-9385530-768x443.png 768w' data-lazy-sizes='(max-width: 1274px) 100vw, 1274px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-8-9385530.png'\/><noscript><img alt='combine-multiple-tables-in-power-bi-8-9385530' width='1274' height='735' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-8-9385530.png' class=\"wp-image-31037\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-8-9385530.png 1274w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-8-9385530-300x173.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-8-9385530-1024x591.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-8-9385530-768x443.png 768w' sizes='(max-width: 1274px) 100vw, 1274px'\/><\/noscript><\/figure>\n<p>To combine the Attenuation Product Category table, right corner of the Attenuation Product Category column heading. Select the required fields from the product category table.<\/p>\n<p>We only need the English product category name from this table<\/p>\n<figure class=\"wp-block-image\"><img alt='combine-multiple-tables-in-power-bi-9-8963943' width='1274' height='733' class=\"wp-image-31038\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-9-8963943.png 1274w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-9-8963943-300x173.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-9-8963943-1024x589.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-9-8963943-768x442.png 768w' data-lazy-sizes='(max-width: 1274px) 100vw, 1274px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-9-8963943.png'\/><noscript><img alt='combine-multiple-tables-in-power-bi-9-8963943' width='1274' height='733' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-9-8963943.png' class=\"wp-image-31038\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-9-8963943.png 1274w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-9-8963943-300x173.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-9-8963943-1024x589.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-9-8963943-768x442.png 768w' sizes='(max-width: 1274px) 100vw, 1274px'\/><\/noscript><\/figure>\n<p>You can now see the name of the product category in English within the product information table.<\/p>\n<figure class=\"wp-block-image\"><img alt='combine-multiple-tables-in-power-bi-10-5749315' width='1274' height='604' class=\"wp-image-31039\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-10-5749315.png 1274w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-10-5749315-300x142.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-10-5749315-1024x485.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-10-5749315-768x364.png 768w' data-lazy-sizes='(max-width: 1274px) 100vw, 1274px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-10-5749315.png'\/><noscript><img alt='combine-multiple-tables-in-power-bi-10-5749315' width='1274' height='604' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-10-5749315.png' class=\"wp-image-31039\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-10-5749315.png 1274w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-10-5749315-300x142.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-10-5749315-1024x485.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-10-5749315-768x364.png 768w' sizes='(max-width: 1274px) 100vw, 1274px'\/><\/noscript><\/figure>\n<p>Let me rename and rearrange the columns and press <strong>Close and apply <\/strong>option under the <strong>Home<\/strong> tongue.<span id=\"ezoic-pub-ad-placeholder-106\" class=\"ezoic-adpicker-ad\"\/><span style=\"display:block !important;float:none;margin-bottom:15px !important;margin-left:0px !important;margin-right:0px !important;margin-top:15px !important;min-height:250px;min-width:300px;text-align:center !important;\" class=\"ezoic-ad banner-1 adtester-container adtester-container-106\" data-ez-name=\"tutorialgateway_org-banner-1\"><span id=\"div-gpt-ad-tutorialgateway_org-banner-1-0\" ezaw=\"300\" ezah=\"250\" style=\"position:relative;z-index:0;display:inline-block;min-height:250px;min-width:300px;\" class=\"ezoic-ad ezoic-adl\"\/><\/span><\/p>\n<figure class=\"wp-block-image\"><img alt='combine-multiple-tables-in-power-bi-11-4464907' width='1312' height='733' class=\"wp-image-31040\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-11-4464907.png 1312w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-11-4464907-300x168.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-11-4464907-1024x572.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-11-4464907-768x429.png 768w' data-lazy-sizes='(max-width: 1312px) 100vw, 1312px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-11-4464907.png'\/><noscript><img alt='combine-multiple-tables-in-power-bi-11-4464907' width='1312' height='733' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-11-4464907.png' class=\"wp-image-31040\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-11-4464907.png 1312w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-11-4464907-300x168.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-11-4464907-1024x572.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-11-4464907-768x429.png 768w' sizes='(max-width: 1312px) 100vw, 1312px'\/><\/noscript><\/figure>\n<p>Let me create a table with this newly created table. As you can see from the screenshot below, we also formatted the Table.<\/p>\n<p class=\"note\"><strong>NOTE:<\/strong> I suggest that you refer to the Create a table and Format a table articles to understand the table creation and formatting options.<\/p>\n<figure class=\"wp-block-image\"><img alt='combine-multiple-tables-in-power-bi-12-5557894' width='1316' height='743' class=\"wp-image-31041\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-12-5557894.png 1316w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-12-5557894-300x169.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-12-5557894-1024x578.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-12-5557894-768x434.png 768w' data-lazy-sizes='(max-width: 1316px) 100vw, 1316px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-12-5557894.png'\/><noscript><img alt='combine-multiple-tables-in-power-bi-12-5557894' width='1316' height='743' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-12-5557894.png' class=\"wp-image-31041\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-12-5557894.png 1316w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-12-5557894-300x169.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-12-5557894-1024x578.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-12-5557894-768x434.png 768w' sizes='(max-width: 1316px) 100vw, 1316px'\/><\/noscript><\/figure>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>Merge multiple tables in Power BI: In real time, your data is in a normalized format, but in some situations, you may need the denormalized data. In this situation,\u2026<\/p>","protected":false},"author":1,"featured_media":85263,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1359,1360],"tags":[],"class_list":["post-85262","post","type-post","status-publish","format-standard","has-post-thumbnail","category-powerbi","category-tutoriales-power-bi"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.0 (Yoast SEO v28.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Combinar varias tablas en Power BI - R Marketing Digital<\/title>\n<meta name=\"description\" content=\"Combinar varias tablas en Power BI: en tiempo real, sus datos est\u00e1n en un formato normalizado, pero en algunas situaciones, es posible que necesite los\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/rmarketingdigital.com\/en\/powerbi\/combinar-varias-tablas-en-power-bi\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Combinar varias tablas en Power BI\" \/>\n<meta property=\"og:description\" content=\"Combinar varias tablas en Power BI: en tiempo real, sus datos est\u00e1n en un formato normalizado, pero en algunas situaciones, es posible que necesite los\" \/>\n<meta property=\"og:url\" content=\"https:\/\/rmarketingdigital.com\/en\/powerbi\/combinar-varias-tablas-en-power-bi\/\" \/>\n<meta property=\"og:site_name\" content=\"R Marketing Digital\" \/>\n<meta property=\"article:published_time\" content=\"2022-09-16T14:33:21+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-7-9497816.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1274\" \/>\n\t<meta property=\"og:image:height\" content=\"734\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"R Marketing Digital\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/combinar-varias-tablas-en-power-bi\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/combinar-varias-tablas-en-power-bi\\\/\"},\"author\":{\"name\":\"R Marketing Digital\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#\\\/schema\\\/person\\\/7c0d9782b2977b840b3740f00c69a73e\"},\"headline\":\"Combinar varias tablas en Power BI\",\"datePublished\":\"2022-09-16T14:33:21+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/combinar-varias-tablas-en-power-bi\\\/\"},\"wordCount\":468,\"image\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/combinar-varias-tablas-en-power-bi\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/rmarketingdigital.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/Combine-Multiple-Tables-in-Power-BI-7-9497816.png\",\"articleSection\":[\"Power BI\",\"Tutoriales PowerBI\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/combinar-varias-tablas-en-power-bi\\\/\",\"url\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/combinar-varias-tablas-en-power-bi\\\/\",\"name\":\"Combinar varias tablas en Power BI - R Marketing Digital\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/combinar-varias-tablas-en-power-bi\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/combinar-varias-tablas-en-power-bi\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/rmarketingdigital.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/Combine-Multiple-Tables-in-Power-BI-7-9497816.png\",\"datePublished\":\"2022-09-16T14:33:21+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#\\\/schema\\\/person\\\/7c0d9782b2977b840b3740f00c69a73e\"},\"description\":\"Combinar varias tablas en Power BI: en tiempo real, sus datos est\u00e1n en un formato normalizado, pero en algunas situaciones, es posible que necesite los\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/combinar-varias-tablas-en-power-bi\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/combinar-varias-tablas-en-power-bi\\\/#primaryimage\",\"url\":\"https:\\\/\\\/rmarketingdigital.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/Combine-Multiple-Tables-in-Power-BI-7-9497816.png\",\"contentUrl\":\"https:\\\/\\\/rmarketingdigital.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/Combine-Multiple-Tables-in-Power-BI-7-9497816.png\",\"width\":1274,\"height\":734,\"caption\":\"combine-multiple-tables-in-power-bi-7-9497816-6256470-png\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#website\",\"url\":\"https:\\\/\\\/rmarketingdigital.com\\\/\",\"name\":\"R Marketing Digital\",\"description\":\"Agencia SEO | Publicidad redes sociales | Community Management\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/rmarketingdigital.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#\\\/schema\\\/person\\\/7c0d9782b2977b840b3740f00c69a73e\",\"name\":\"R Marketing Digital\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c5599c203e0120b8ccbff4666af86f35f9b3dcad468a8bc6295313a3964a80be?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c5599c203e0120b8ccbff4666af86f35f9b3dcad468a8bc6295313a3964a80be?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c5599c203e0120b8ccbff4666af86f35f9b3dcad468a8bc6295313a3964a80be?s=96&d=mm&r=g\",\"caption\":\"R Marketing Digital\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Merge multiple tables in Power BI - R Marketing Digital","description":"Merge multiple tables in Power BI: In real time, your data is in a standardized format, but in some situations, you may need the","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:\/\/rmarketingdigital.com\/en\/powerbi\/combinar-varias-tablas-en-power-bi\/","og_locale":"en_US","og_type":"article","og_title":"Combinar varias tablas en Power BI","og_description":"Combinar varias tablas en Power BI: en tiempo real, sus datos est\u00e1n en un formato normalizado, pero en algunas situaciones, es posible que necesite los","og_url":"https:\/\/rmarketingdigital.com\/en\/powerbi\/combinar-varias-tablas-en-power-bi\/","og_site_name":"R Marketing Digital","article_published_time":"2022-09-16T14:33:21+00:00","og_image":[{"width":1274,"height":734,"url":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-7-9497816.png","type":"image\/png"}],"author":"R Marketing Digital","twitter_card":"summary_large_image","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/rmarketingdigital.com\/powerbi\/combinar-varias-tablas-en-power-bi\/#article","isPartOf":{"@id":"https:\/\/rmarketingdigital.com\/powerbi\/combinar-varias-tablas-en-power-bi\/"},"author":{"name":"R Marketing Digital","@id":"https:\/\/rmarketingdigital.com\/#\/schema\/person\/7c0d9782b2977b840b3740f00c69a73e"},"headline":"Combinar varias tablas en Power BI","datePublished":"2022-09-16T14:33:21+00:00","mainEntityOfPage":{"@id":"https:\/\/rmarketingdigital.com\/powerbi\/combinar-varias-tablas-en-power-bi\/"},"wordCount":468,"image":{"@id":"https:\/\/rmarketingdigital.com\/powerbi\/combinar-varias-tablas-en-power-bi\/#primaryimage"},"thumbnailUrl":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-7-9497816.png","articleSection":["Power BI","Tutoriales PowerBI"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/rmarketingdigital.com\/powerbi\/combinar-varias-tablas-en-power-bi\/","url":"https:\/\/rmarketingdigital.com\/powerbi\/combinar-varias-tablas-en-power-bi\/","name":"Merge multiple tables in Power BI - R Marketing Digital","isPartOf":{"@id":"https:\/\/rmarketingdigital.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/rmarketingdigital.com\/powerbi\/combinar-varias-tablas-en-power-bi\/#primaryimage"},"image":{"@id":"https:\/\/rmarketingdigital.com\/powerbi\/combinar-varias-tablas-en-power-bi\/#primaryimage"},"thumbnailUrl":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-7-9497816.png","datePublished":"2022-09-16T14:33:21+00:00","author":{"@id":"https:\/\/rmarketingdigital.com\/#\/schema\/person\/7c0d9782b2977b840b3740f00c69a73e"},"description":"Merge multiple tables in Power BI: In real time, your data is in a standardized format, but in some situations, you may need the","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/rmarketingdigital.com\/powerbi\/combinar-varias-tablas-en-power-bi\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/rmarketingdigital.com\/powerbi\/combinar-varias-tablas-en-power-bi\/#primaryimage","url":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-7-9497816.png","contentUrl":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Combine-Multiple-Tables-in-Power-BI-7-9497816.png","width":1274,"height":734,"caption":"combine-multiple-tables-in-power-bi-7-9497816-6256470-png"},{"@type":"WebSite","@id":"https:\/\/rmarketingdigital.com\/#website","url":"https:\/\/rmarketingdigital.com\/","name":"R Digital Marketing","description":"SEO Agency | Advertising social networks | Community Management","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/rmarketingdigital.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/rmarketingdigital.com\/#\/schema\/person\/7c0d9782b2977b840b3740f00c69a73e","name":"R Digital Marketing","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/c5599c203e0120b8ccbff4666af86f35f9b3dcad468a8bc6295313a3964a80be?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/c5599c203e0120b8ccbff4666af86f35f9b3dcad468a8bc6295313a3964a80be?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c5599c203e0120b8ccbff4666af86f35f9b3dcad468a8bc6295313a3964a80be?s=96&d=mm&r=g","caption":"R Marketing Digital"}}]}},"_links":{"self":[{"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/posts\/85262","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/comments?post=85262"}],"version-history":[{"count":0,"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/posts\/85262\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/media\/85263"}],"wp:attachment":[{"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/media?parent=85262"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/categories?post=85262"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/tags?post=85262"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}