{"id":85040,"date":"2022-09-14T16:12:40","date_gmt":"2022-09-14T14:12:40","guid":{"rendered":"https:\/\/rmarketingdigital.com\/powerbi\/se-une-en-power-bi\/"},"modified":"2020-09-17T20:11:54","modified_gmt":"2020-09-17T23:11:54","slug":"se-une-en-power-bi","status":"publish","type":"post","link":"https:\/\/rmarketingdigital.com\/de\/energiebi\/se-une-en-power-bi\/","title":{"rendered":"Machen Sie mit bei Power BI"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_86 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Inhalt<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Inhaltsverzeichnis umschalten\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Umschalten<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewbox=\"0 0 24 24\" version=\"1.2\" baseprofile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/rmarketingdigital.com\/de\/energiebi\/se-une-en-power-bi\/#Como-realizar-uniones-en-Power-BI\" >So treten Sie Power BI bei<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/rmarketingdigital.com\/de\/energiebi\/se-une-en-power-bi\/#Union-externa-izquierda-en-Power-BI\" >Linke \u00e4u\u00dfere Verkn\u00fcpfung in Power BI<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/rmarketingdigital.com\/de\/energiebi\/se-une-en-power-bi\/#Union-externa-derecha-en-Power-BI\" >Rechter \u00e4u\u00dferer Join in Power BI<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/rmarketingdigital.com\/de\/energiebi\/se-une-en-power-bi\/#Union-externa-completa-en-Power-BI\" >Vollst\u00e4ndiger \u00e4u\u00dferer Join in Power BI<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/rmarketingdigital.com\/de\/energiebi\/se-une-en-power-bi\/#Union-interna-en-Power-BI\" >Interner Join in Power BI<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<div>\n<p>Power BI unterst\u00fctzt alle Hauptverkn\u00fcpfungen, die in SQL verf\u00fcgbar sind. Lassen Sie mich Ihnen anhand eines Beispiels zeigen, wie Sie Joins in Power BI verwenden, um mehrere Tabellen zu verkn\u00fcpfen.<\/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\"\/><\/span><\/p>\n<p>Die folgenden Verkn\u00fcpfungstypen sind die Standardverkn\u00fcpfungstypen in Power BI und SQL<\/p>\n<ol>\n<li>Inner Join: Gibt die Zeilen in der linken und rechten Tabelle nur zur\u00fcck, wenn eine \u00dcbereinstimmung vorliegt. Andernfalls werden keine Datens\u00e4tze zur\u00fcckgegeben.<\/li>\n<li>Vollst\u00e4ndige \u00e4u\u00dfere Verkn\u00fcpfung: Gibt alle Zeilen zur\u00fcck, die in der linken und rechten Tabelle vorhanden sind.<\/li>\n<li>Linker \u00e4u\u00dferer Join - Gibt alle in der linken Tabelle vorhandenen Zeilen und die \u00fcbereinstimmenden Zeilen in der rechten Tabelle zur\u00fcck (falls vorhanden).<\/li>\n<li>Rechter \u00e4u\u00dferer Join - Gibt \u00fcbereinstimmende Zeilen aus der linken Tabelle (falls zutreffend) und alle vorhandenen Zeilen aus der rechten SQL-Tabelle zur\u00fcck.<\/li>\n<\/ol>\n<h2><span class=\"ez-toc-section\" id=\"Como-realizar-uniones-en-Power-BI\"><\/span>So treten Sie Power BI bei<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Um die Power BI-Verkn\u00fcpfungstypen zu demonstrieren, verwenden wir die Tabellen, die wir im Artikel Laden von Daten aus mehreren Datenquellen importiert haben.<\/p>\n<p>Klicken Sie auf, um Verkn\u00fcpfungsvorg\u00e4nge f\u00fcr vorhandene Tabellen anzuzeigen <b>Abfragen bearbeiten<\/b> Option unter der <b>Zuhause<\/b> Zunge.<\/p>\n<figure class=\"wp-block-image\"><img alt='Joins-in-Power-Bi-1-3974668' width='1032' height='576' class=\"wp-image-31007\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-1-3974668.png 1032w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-1-3974668-300x167.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-1-3974668-1024x572.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-1-3974668-768x429.png 768w' data-lazy-sizes='(max-width: 1032px) 100vw, 1032px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-1-3974668.png'\/><noscript><img alt='Joins-in-Power-Bi-1-3974668' width='1032' height='576' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-1-3974668.png' class=\"wp-image-31007\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-1-3974668.png 1032w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-1-3974668-300x167.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-1-3974668-1024x572.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-1-3974668-768x429.png 768w' sizes='(max-width: 1032px) 100vw, 1032px'\/><\/noscript><\/figure>\n<p>Der folgende Power BI-Screenshot zeigt die in der Employees-Tabelle enthaltenen Daten<\/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\"\/><\/span><\/p>\n<figure class=\"wp-block-image\"><img alt='Joins-in-Power-Bi-2-1937040' width='1274' height='607' class=\"wp-image-31008\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-2-1937040.png 1274w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-2-1937040-300x143.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-2-1937040-1024x488.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-2-1937040-768x366.png 768w' data-lazy-sizes='(max-width: 1274px) 100vw, 1274px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-2-1937040.png'\/><noscript><img alt='Joins-in-Power-Bi-2-1937040' width='1274' height='607' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-2-1937040.png' class=\"wp-image-31008\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-2-1937040.png 1274w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-2-1937040-300x143.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-2-1937040-1024x488.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-2-1937040-768x366.png 768w' sizes='(max-width: 1274px) 100vw, 1274px'\/><\/noscript><\/figure>\n<p>Der folgende Screenshot zeigt die in der Abteilungstabelle vorhandenen Daten.<\/p>\n<p>Um Power BI-Verkn\u00fcpfungsvorg\u00e4nge f\u00fcr eine beliebige Tabelle auszuf\u00fchren, m\u00fcssen Sie die verwenden <strong>Abfragen zusammenf\u00fchren<\/strong> Taste auf der <strong>Zuhause<\/strong> Zunge<\/p>\n<figure class=\"wp-block-image\"><img alt='Joins-in-Power-Bi-3-6668174' width='1275' height='608' class=\"wp-image-31009\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-3-6668174.png 1275w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-3-6668174-300x143.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-3-6668174-1024x488.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-3-6668174-768x366.png 768w' data-lazy-sizes='(max-width: 1275px) 100vw, 1275px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-3-6668174.png'\/><noscript><img alt='Joins-in-Power-Bi-3-6668174' width='1275' height='608' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-3-6668174.png' class=\"wp-image-31009\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-3-6668174.png 1275w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-3-6668174-300x143.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-3-6668174-1024x488.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-3-6668174-768x366.png 768w' sizes='(max-width: 1275px) 100vw, 1275px'\/><\/noscript><\/figure>\n<p>Diese Dropdown-Liste bietet zwei Optionen:<\/p>\n<ul>\n<li><b>Abfragen zusammenf\u00fchren:<\/b> F\u00fchren Sie die zweite Tabelle in diese urspr\u00fcngliche Tabelle ein.<\/li>\n<li><b>Abfragen wie neu zusammenf\u00fchren:<\/b> Erstellen Sie eine neue Tabelle mit dem Ergebnis des Verbindens der ersten und zweiten Tabelle.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt='Joins-in-Power-Bi-4-3514335' width='1275' height='608' class=\"wp-image-31010\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-4-3514335.png 1275w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-4-3514335-300x143.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-4-3514335-1024x488.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-4-3514335-768x366.png 768w' data-lazy-sizes='(max-width: 1275px) 100vw, 1275px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-4-3514335.png'\/><noscript><img alt='Joins-in-Power-Bi-4-3514335' width='1275' height='608' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-4-3514335.png' class=\"wp-image-31010\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-4-3514335.png 1275w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-4-3514335-300x143.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-4-3514335-1024x488.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-4-3514335-768x366.png 768w' sizes='(max-width: 1275px) 100vw, 1275px'\/><\/noscript><\/figure>\n<p>Lassen Sie mich die Tabelle Mitarbeiter ausw\u00e4hlen und ausw\u00e4hlen <strong>F\u00fchren Sie Abfragen als neue zusammen<\/strong> Option, da wir die urspr\u00fcngliche Tabelle nicht \u00e4ndern m\u00f6chten<\/p>\n<figure class=\"wp-block-image\"><img alt='Joins-in-Power-Bi-5-5810264' width='1275' height='607' class=\"wp-image-31011\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-5-5810264.png 1275w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-5-5810264-300x143.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-5-5810264-1024x488.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-5-5810264-768x366.png 768w' data-lazy-sizes='(max-width: 1275px) 100vw, 1275px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-5-5810264.png'\/><noscript><img alt='Joins-in-Power-Bi-5-5810264' width='1275' height='607' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-5-5810264.png' class=\"wp-image-31011\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-5-5810264.png 1275w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-5-5810264-300x143.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-5-5810264-1024x488.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-5-5810264-768x366.png 768w' sizes='(max-width: 1275px) 100vw, 1275px'\/><\/noscript><\/figure>\n<p>Das folgende Fenster wird ge\u00f6ffnet. In diesem Fenster k\u00f6nnen Sie die zweite Tabelle, den Verkn\u00fcpfungstyp und die archivierte Standardspalte in beiden Tabellen ausw\u00e4hlen.<\/p>\n<figure class=\"wp-block-image\"><img alt='Joins-in-Power-Bi-6-2491038' width='698' height='601' class=\"wp-image-31012\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-6-2491038.png 698w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-6-2491038-300x258.png 300w' data-lazy-sizes='(max-width: 698px) 100vw, 698px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-6-2491038.png'\/><noscript><img alt='Joins-in-Power-Bi-6-2491038' width='698' height='601' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-6-2491038.png' class=\"wp-image-31012\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-6-2491038.png 698w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-6-2491038-300x258.png 300w' sizes='(max-width: 698px) 100vw, 698px'\/><\/noscript><\/figure>\n<p>Wir w\u00e4hlen die Abteilungstabelle als zweite Tabelle aus.<\/p>\n<figure class=\"wp-block-image\"><img alt='Joins-in-Power-Bi-7-1578265' width='699' height='601' class=\"wp-image-31013\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-7-1578265.png 699w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-7-1578265-300x258.png 300w' data-lazy-sizes='(max-width: 699px) 100vw, 699px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-7-1578265.png'\/><noscript><img alt='Joins-in-Power-Bi-7-1578265' width='699' height='601' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-7-1578265.png' class=\"wp-image-31013\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-7-1578265.png 699w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-7-1578265-300x258.png 300w' sizes='(max-width: 699px) 100vw, 699px'\/><\/noscript><\/figure>\n<p>Jetzt k\u00f6nnen Sie die Liste der unterst\u00fctzten Join-Typen anzeigen.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Union-externa-izquierda-en-Power-BI\"><\/span>Linke \u00e4u\u00dfere Verkn\u00fcpfung in Power BI<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Im Moment w\u00e4hlen wir den linken \u00e4u\u00dferen Join aus<\/p>\n<figure class=\"wp-block-image\"><img alt='Joins-in-Power-Bi-8-9965058' width='700' height='601' class=\"wp-image-31014\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-8-9965058.png 700w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-8-9965058-300x258.png 300w' data-lazy-sizes='(max-width: 700px) 100vw, 700px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-8-9965058.png'\/><noscript><img alt='Joins-in-Power-Bi-8-9965058' width='700' height='601' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-8-9965058.png' class=\"wp-image-31014\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-8-9965058.png 700w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-8-9965058-300x258.png 300w' sizes='(max-width: 700px) 100vw, 700px'\/><\/noscript><\/figure>\n<p>Als N\u00e4chstes w\u00e4hlen wir die DeptID aus der Tabelle Mitarbeiter und Abteilung als allgemeine Felder aus<\/p>\n<figure class=\"wp-block-image\"><img alt='Joins-in-Power-Bi-9-5048694' width='700' height='601' class=\"wp-image-31015\" srcset='' data-lazy-sizes='(max-width: 700px) 100vw, 700px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-9-5048694.png'\/><noscript><img alt='Joins-in-Power-Bi-9-5048694' width='700' height='601' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-9-5048694.png' class=\"wp-image-31015\" srcset='' sizes='(max-width: 700px) 100vw, 700px'\/><\/noscript><\/figure>\n<p>Jetzt k\u00f6nnen Sie die neue Tabelle mit dem Namen Merge1 mit allen Feldern aus der Employees-Tabelle sowie einer zus\u00e4tzlichen Datei der Wertetabelle anzeigen<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;width:100%;max-width:1200px;margin-left:auto !important;margin-right:auto !important;min-height:250px;min-width:300px;\" class=\"ezoic-ad\"\/><\/span><\/p>\n<figure class=\"wp-block-image\"><img alt='Joins-in-Power-Bi-10-9039746' width='1393' height='608' class=\"wp-image-31016\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-10-9039746.png 1393w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-10-9039746-300x131.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-10-9039746-1024x447.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-10-9039746-768x335.png 768w' data-lazy-sizes='(max-width: 1393px) 100vw, 1393px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-10-9039746.png'\/><noscript><img alt='Joins-in-Power-Bi-10-9039746' width='1393' height='608' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-10-9039746.png' class=\"wp-image-31016\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-10-9039746.png 1393w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-10-9039746-300x131.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-10-9039746-1024x447.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-10-9039746-768x335.png 768w' sizes='(max-width: 1393px) 100vw, 1393px'\/><\/noscript><\/figure>\n<p>Klicken Sie auf die Tabelle in einer beliebigen Zeile, um die Informationen der jeweiligen Tabelle anzuzeigen<\/p>\n<figure class=\"wp-block-image\"><img alt='Joins-in-Power-Bi-11-7901567' width='1393' height='611' class=\"wp-image-31017\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-11-7901567.png 1393w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-11-7901567-300x132.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-11-7901567-1024x449.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-11-7901567-768x337.png 768w' data-lazy-sizes='(max-width: 1393px) 100vw, 1393px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-11-7901567.png'\/><noscript><img alt='Joins-in-Power-Bi-11-7901567' width='1393' height='611' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-11-7901567.png' class=\"wp-image-31017\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-11-7901567.png 1393w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-11-7901567-300x132.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-11-7901567-1024x449.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-11-7901567-768x337.png 768w' sizes='(max-width: 1393px) 100vw, 1393px'\/><\/noscript><\/figure>\n<p>Klicken Sie in die rechte Ecke der Spalten\u00fcberschrift Abteilung. Dies \u00f6ffnet das folgende Fenster. In diesem Fenster k\u00f6nnen Sie die erforderlichen Felder aus der Abteilungstabelle ausw\u00e4hlen.<\/p>\n<figure class=\"wp-block-image\"><img alt='Joins-in-Power-Bi-12-4538219' width='1328' height='659' class=\"wp-image-31018\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-12-4538219.png 1328w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-12-4538219-300x149.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-12-4538219-1024x508.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-12-4538219-768x381.png 768w' data-lazy-sizes='(max-width: 1328px) 100vw, 1328px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-12-4538219.png'\/><noscript><img alt='Joins-in-Power-Bi-12-4538219' width='1328' height='659' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-12-4538219.png' class=\"wp-image-31018\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-12-4538219.png 1328w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-12-4538219-300x149.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-12-4538219-1024x508.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-12-4538219-768x381.png 768w' sizes='(max-width: 1328px) 100vw, 1328px'\/><\/noscript><\/figure>\n<p>Lassen Sie mich den Abteilungsnamen aus der Abteilungstabelle ausw\u00e4hlen und auf OK klicken<\/p>\n<figure class=\"wp-block-image\"><img alt='Joins-in-Power-Bi-13-4506339' width='1192' height='586' class=\"wp-image-31019\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-13-4506339.png 1192w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-13-4506339-300x147.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-13-4506339-1024x503.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-13-4506339-768x378.png 768w' data-lazy-sizes='(max-width: 1192px) 100vw, 1192px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-13-4506339.png'\/><noscript><img alt='Joins-in-Power-Bi-13-4506339' width='1192' height='586' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-13-4506339.png' class=\"wp-image-31019\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-13-4506339.png 1192w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-13-4506339-300x147.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-13-4506339-1024x503.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-13-4506339-768x378.png 768w' sizes='(max-width: 1192px) 100vw, 1192px'\/><\/noscript><\/figure>\n<p>Jetzt k\u00f6nnen Sie sehen, dass der Abteilungsname mit der Employee-Tabelle zusammengef\u00fchrt wird.<\/p>\n<figure class=\"wp-block-image\"><img alt='Joins-in-Power-Bi-14-6134242' width='1293' height='585' class=\"wp-image-31020\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-14-6134242.png 1293w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-14-6134242-300x136.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-14-6134242-1024x463.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-14-6134242-768x347.png 768w' data-lazy-sizes='(max-width: 1293px) 100vw, 1293px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-14-6134242.png'\/><noscript><img alt='Joins-in-Power-Bi-14-6134242' width='1293' height='585' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-14-6134242.png' class=\"wp-image-31020\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-14-6134242.png 1293w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-14-6134242-300x136.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-14-6134242-1024x463.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-14-6134242-768x347.png 768w' sizes='(max-width: 1293px) 100vw, 1293px'\/><\/noscript><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Union-externa-derecha-en-Power-BI\"><\/span>Rechter \u00e4u\u00dferer Join in Power BI<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Lassen Sie mich die Tabelle &quot;Mitarbeiter&quot; als erste Tabelle und die Tabelle &quot;Abteilung&quot; als zweite Tabelle ausw\u00e4hlen. Die Abteilungs-ID ist die allgemeine Datei und der rechte \u00e4u\u00dfere Join als Join-Typ.<\/p>\n<figure class=\"wp-block-image\"><img alt='Joins-in-Power-Bi-15-4156651' width='700' height='601' class=\"wp-image-31021\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-15-4156651.png 700w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-15-4156651-300x258.png 300w' data-lazy-sizes='(max-width: 700px) 100vw, 700px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-15-4156651.png'\/><noscript><img alt='Joins-in-Power-Bi-15-4156651' width='700' height='601' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-15-4156651.png' class=\"wp-image-31021\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-15-4156651.png 700w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-15-4156651-300x258.png 300w' sizes='(max-width: 700px) 100vw, 700px'\/><\/noscript><\/figure>\n<p>Jetzt k\u00f6nnen Sie das Ergebnis der neuen Power BI-Tabelle f\u00fcr die \u00e4u\u00dfere \u00e4u\u00dfere Verkn\u00fcpfung sehen<\/p>\n<figure class=\"wp-block-image\"><img alt='Joins-in-Power-Bi-16-6712831' width='1239' height='538' class=\"wp-image-31023\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-16-6712831.png 1239w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-16-6712831-300x130.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-16-6712831-1024x445.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-16-6712831-768x333.png 768w' data-lazy-sizes='(max-width: 1239px) 100vw, 1239px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-16-6712831.png'\/><noscript><img alt='Joins-in-Power-Bi-16-6712831' width='1239' height='538' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-16-6712831.png' class=\"wp-image-31023\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-16-6712831.png 1239w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-16-6712831-300x130.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-16-6712831-1024x445.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-16-6712831-768x333.png 768w' sizes='(max-width: 1239px) 100vw, 1239px'\/><\/noscript><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Union-externa-completa-en-Power-BI\"><\/span>Vollst\u00e4ndiger \u00e4u\u00dferer Join in Power BI<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Lassen Sie mich die Tabelle &quot;Mitarbeiter&quot; als erste Tabelle und die Tabelle &quot;Abteilung&quot; als zweite Tabelle ausw\u00e4hlen. Hier w\u00e4hlen wir Dept ID ist die allgemeine Datei und die vollst\u00e4ndige \u00e4u\u00dfere Verkn\u00fcpfung als Verkn\u00fcpfungstyp.<\/p>\n<figure class=\"wp-block-image\"><img alt='Joins-in-Power-Bi-17-9792915' width='700' height='601' class=\"wp-image-31024\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-17-9792915.png 700w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-17-9792915-300x258.png 300w' data-lazy-sizes='(max-width: 700px) 100vw, 700px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-17-9792915.png'\/><noscript><img alt='Joins-in-Power-Bi-17-9792915' width='700' height='601' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-17-9792915.png' class=\"wp-image-31024\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-17-9792915.png 700w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-17-9792915-300x258.png 300w' sizes='(max-width: 700px) 100vw, 700px'\/><\/noscript><\/figure>\n<p>Sie k\u00f6nnen jetzt das Ergebnis des vollst\u00e4ndigen \u00e4u\u00dferen Power BI-Joins in einer neuen Tabelle anzeigen<\/p>\n<figure class=\"wp-block-image\"><img alt='Joins-in-Power-Bi-18-4511537' width='1239' height='599' class=\"wp-image-31025\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-18-4511537.png 1239w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-18-4511537-300x145.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-18-4511537-1024x495.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-18-4511537-768x371.png 768w' data-lazy-sizes='(max-width: 1239px) 100vw, 1239px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-18-4511537.png'\/><noscript><img alt='Joins-in-Power-Bi-18-4511537' width='1239' height='599' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-18-4511537.png' class=\"wp-image-31025\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-18-4511537.png 1239w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-18-4511537-300x145.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-18-4511537-1024x495.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-18-4511537-768x371.png 768w' sizes='(max-width: 1239px) 100vw, 1239px'\/><\/noscript><\/figure>\n<h3><span class=\"ez-toc-section\" id=\"Union-interna-en-Power-BI\"><\/span>Interner Join in Power BI<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Lassen Sie mich Tabellen Mitarbeiter und Abteilungen ausw\u00e4hlen, Abteilungs-ID als gemeinsam, innere Verkn\u00fcpfung als Verkn\u00fcpfungstyp<\/p>\n<figure class=\"wp-block-image\"><img alt='Joins-in-Power-Bi-19-7406899' width='700' height='601' class=\"wp-image-31026\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-19-7406899.png 700w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-19-7406899-300x258.png 300w' data-lazy-sizes='(max-width: 700px) 100vw, 700px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-19-7406899.png'\/><noscript><img alt='Joins-in-Power-Bi-19-7406899' width='700' height='601' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-19-7406899.png' class=\"wp-image-31026\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-19-7406899.png 700w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-19-7406899-300x258.png 300w' sizes='(max-width: 700px) 100vw, 700px'\/><\/noscript><\/figure>\n<p>Sie k\u00f6nnen jetzt das Ergebnis des inneren Power BI-Joins in einer neuen Tabelle sehen<\/p>\n<figure class=\"wp-block-image\"><img alt='Joins-in-Power-Bi-20-9503405' width='1213' height='599' class=\"wp-image-31027\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-20-9503405.png 1213w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-20-9503405-300x148.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-20-9503405-1024x506.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-20-9503405-768x379.png 768w' data-lazy-sizes='(max-width: 1213px) 100vw, 1213px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-20-9503405.png'\/><noscript><img alt='Joins-in-Power-Bi-20-9503405' width='1213' height='599' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-20-9503405.png' class=\"wp-image-31027\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-20-9503405.png 1213w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-20-9503405-300x148.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-20-9503405-1024x506.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-20-9503405-768x379.png 768w' sizes='(max-width: 1213px) 100vw, 1213px'\/><\/noscript><\/figure>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>Power BI admite todas las combinaciones principales que est\u00e1n disponibles en SQL. Perm\u00edtame mostrarle c\u00f3mo usar combinaciones en Power BI para unir varias tablas con un ejemplo. Los siguientes tipos&#8230;<\/p>","protected":false},"author":1,"featured_media":85041,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1359,1360],"tags":[],"class_list":["post-85040","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>Se une en Power BI - R Marketing Digital<\/title>\n<meta name=\"description\" content=\"Power BI admite todas las combinaciones principales que est\u00e1n disponibles en SQL. Perm\u00edtame mostrarle c\u00f3mo usar combinaciones en Power BI para unir varias\" \/>\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\/de\/energiebi\/joins-in-power-bi\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Se une en Power BI\" \/>\n<meta property=\"og:description\" content=\"Power BI admite todas las combinaciones principales que est\u00e1n disponibles en SQL. Perm\u00edtame mostrarle c\u00f3mo usar combinaciones en Power BI para unir varias\" \/>\n<meta property=\"og:url\" content=\"https:\/\/rmarketingdigital.com\/de\/energiebi\/joins-in-power-bi\/\" \/>\n<meta property=\"og:site_name\" content=\"R Marketing Digital\" \/>\n<meta property=\"article:published_time\" content=\"2022-09-14T14:12:40+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-8-4564752.png\" \/>\n\t<meta property=\"og:image:width\" content=\"700\" \/>\n\t<meta property=\"og:image:height\" content=\"601\" \/>\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\\\/de\\\/powerbi\\\/joins-in-power-bi\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/de\\\/powerbi\\\/joins-in-power-bi\\\/\"},\"author\":{\"name\":\"R Marketing Digital\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#\\\/schema\\\/person\\\/7c0d9782b2977b840b3740f00c69a73e\"},\"headline\":\"Se une en Power BI\",\"datePublished\":\"2022-09-14T14:12:40+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/de\\\/powerbi\\\/joins-in-power-bi\\\/\"},\"wordCount\":670,\"image\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/de\\\/powerbi\\\/joins-in-power-bi\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/rmarketingdigital.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/Joins-in-Power-BI-8-4564752.png\",\"articleSection\":[\"Power BI\",\"Tutoriales PowerBI\"],\"inLanguage\":\"de\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/de\\\/powerbi\\\/joins-in-power-bi\\\/\",\"url\":\"https:\\\/\\\/rmarketingdigital.com\\\/de\\\/powerbi\\\/joins-in-power-bi\\\/\",\"name\":\"Se une en Power BI - R Marketing Digital\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/de\\\/powerbi\\\/joins-in-power-bi\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/de\\\/powerbi\\\/joins-in-power-bi\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/rmarketingdigital.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/Joins-in-Power-BI-8-4564752.png\",\"datePublished\":\"2022-09-14T14:12:40+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#\\\/schema\\\/person\\\/7c0d9782b2977b840b3740f00c69a73e\"},\"description\":\"Power BI admite todas las combinaciones principales que est\u00e1n disponibles en SQL. Perm\u00edtame mostrarle c\u00f3mo usar combinaciones en Power BI para unir varias\",\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/rmarketingdigital.com\\\/de\\\/powerbi\\\/joins-in-power-bi\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/de\\\/powerbi\\\/joins-in-power-bi\\\/#primaryimage\",\"url\":\"https:\\\/\\\/rmarketingdigital.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/Joins-in-Power-BI-8-4564752.png\",\"contentUrl\":\"https:\\\/\\\/rmarketingdigital.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/Joins-in-Power-BI-8-4564752.png\",\"width\":700,\"height\":601,\"caption\":\"joins-in-power-bi-8-4564752-7919670-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\":\"de\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#\\\/schema\\\/person\\\/7c0d9782b2977b840b3740f00c69a73e\",\"name\":\"R Marketing Digital\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@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":"Schlie\u00dft sich Power BI an - R Marketing Digital","description":"Power BI unterst\u00fctzt alle Hauptverkn\u00fcpfungen, die in SQL verf\u00fcgbar sind. Lassen Sie mich Ihnen zeigen, wie Sie Joins in Power BI verwenden, um mehrere zu verbinden","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\/de\/energiebi\/joins-in-power-bi\/","og_locale":"de_DE","og_type":"article","og_title":"Se une en Power BI","og_description":"Power BI admite todas las combinaciones principales que est\u00e1n disponibles en SQL. Perm\u00edtame mostrarle c\u00f3mo usar combinaciones en Power BI para unir varias","og_url":"https:\/\/rmarketingdigital.com\/de\/energiebi\/joins-in-power-bi\/","og_site_name":"R Marketing Digital","article_published_time":"2022-09-14T14:12:40+00:00","og_image":[{"width":700,"height":601,"url":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-8-4564752.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\/de\/powerbi\/joins-in-power-bi\/#article","isPartOf":{"@id":"https:\/\/rmarketingdigital.com\/de\/powerbi\/joins-in-power-bi\/"},"author":{"name":"R Marketing Digital","@id":"https:\/\/rmarketingdigital.com\/#\/schema\/person\/7c0d9782b2977b840b3740f00c69a73e"},"headline":"Se une en Power BI","datePublished":"2022-09-14T14:12:40+00:00","mainEntityOfPage":{"@id":"https:\/\/rmarketingdigital.com\/de\/powerbi\/joins-in-power-bi\/"},"wordCount":670,"image":{"@id":"https:\/\/rmarketingdigital.com\/de\/powerbi\/joins-in-power-bi\/#primaryimage"},"thumbnailUrl":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-8-4564752.png","articleSection":["Power BI","Tutoriales PowerBI"],"inLanguage":"de"},{"@type":"WebPage","@id":"https:\/\/rmarketingdigital.com\/de\/powerbi\/joins-in-power-bi\/","url":"https:\/\/rmarketingdigital.com\/de\/powerbi\/joins-in-power-bi\/","name":"Schlie\u00dft sich Power BI an - R Marketing Digital","isPartOf":{"@id":"https:\/\/rmarketingdigital.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/rmarketingdigital.com\/de\/powerbi\/joins-in-power-bi\/#primaryimage"},"image":{"@id":"https:\/\/rmarketingdigital.com\/de\/powerbi\/joins-in-power-bi\/#primaryimage"},"thumbnailUrl":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-8-4564752.png","datePublished":"2022-09-14T14:12:40+00:00","author":{"@id":"https:\/\/rmarketingdigital.com\/#\/schema\/person\/7c0d9782b2977b840b3740f00c69a73e"},"description":"Power BI unterst\u00fctzt alle Hauptverkn\u00fcpfungen, die in SQL verf\u00fcgbar sind. Lassen Sie mich Ihnen zeigen, wie Sie Joins in Power BI verwenden, um mehrere zu verbinden","inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/rmarketingdigital.com\/de\/powerbi\/joins-in-power-bi\/"]}]},{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/rmarketingdigital.com\/de\/powerbi\/joins-in-power-bi\/#primaryimage","url":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-8-4564752.png","contentUrl":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Joins-in-Power-BI-8-4564752.png","width":700,"height":601,"caption":"joins-in-power-bi-8-4564752-7919670-png"},{"@type":"WebSite","@id":"https:\/\/rmarketingdigital.com\/#website","url":"https:\/\/rmarketingdigital.com\/","name":"R Digitales Marketing","description":"SEO Agentur | Werbung f\u00fcr soziale Netzwerke | 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":"de"},{"@type":"Person","@id":"https:\/\/rmarketingdigital.com\/#\/schema\/person\/7c0d9782b2977b840b3740f00c69a73e","name":"R Digitales Marketing","image":{"@type":"ImageObject","inLanguage":"de","@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\/de\/wp-json\/wp\/v2\/posts\/85040","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rmarketingdigital.com\/de\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rmarketingdigital.com\/de\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rmarketingdigital.com\/de\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rmarketingdigital.com\/de\/wp-json\/wp\/v2\/comments?post=85040"}],"version-history":[{"count":0,"href":"https:\/\/rmarketingdigital.com\/de\/wp-json\/wp\/v2\/posts\/85040\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/rmarketingdigital.com\/de\/wp-json\/wp\/v2\/media\/85041"}],"wp:attachment":[{"href":"https:\/\/rmarketingdigital.com\/de\/wp-json\/wp\/v2\/media?parent=85040"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rmarketingdigital.com\/de\/wp-json\/wp\/v2\/categories?post=85040"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rmarketingdigital.com\/de\/wp-json\/wp\/v2\/tags?post=85040"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}