{"id":85386,"date":"2022-10-06T15:31:04","date_gmt":"2022-10-06T13:31:04","guid":{"rendered":"https:\/\/rmarketingdigital.com\/powerbi\/conecte-power-bi-a-varias-hojas-de-excel\/"},"modified":"2020-09-18T01:00:31","modified_gmt":"2020-09-18T04:00:31","slug":"conecte-power-bi-a-varias-hojas-de-excel","status":"publish","type":"post","link":"https:\/\/rmarketingdigital.com\/de\/energiebi\/conecte-power-bi-a-varias-hojas-de-excel\/","title":{"rendered":"Verbinden Sie Power BI mit mehreren Excel-Tabellen"},"content":{"rendered":"<div>\n<p>In diesem Artikel zeigen wir Ihnen, wie Sie Power BI mit mehreren Excel-Tabellen verbinden und die in diesen Excel-Tabellen enthaltenen Daten verwenden.<\/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<p>Um die Power BI-Verbindung zu mehreren Excel-Tabellen zu demonstrieren, laden wir Daten aus mehreren Tabellen oder Tabellen in eine Excel-Datei in Power BI und generieren ein Balkendiagramm.<\/p>\n<h2>So verbinden Sie Power BI mit mehreren Excel-Tabellen<\/h2>\n<p>Bevor wir Power BI mit mehreren Excel-Tabellen verbinden, schauen wir uns die Daten in der Beispiel-Superstore-Excel-Datei an. Im folgenden Screenshot sehen Sie, dass Sie drei Bl\u00e4tter Bestellungen, Retouren und Benutzer haben<\/p>\n<figure class=\"wp-block-image\"><img alt='Connect-Power-Bi-to-Multiple-Excel-Sheets-1-9885948' width='1118' height='616' class=\"wp-image-30227\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-1-9885948.png 1118w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-1-9885948-300x165.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-1-9885948-1024x564.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-1-9885948-768x423.png 768w' data-lazy-sizes='(max-width: 1118px) 100vw, 1118px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-1-9885948.png'\/><noscript><img alt='Connect-Power-Bi-to-Multiple-Excel-Sheets-1-9885948' width='1118' height='616' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-1-9885948.png' class=\"wp-image-30227\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-1-9885948.png 1118w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-1-9885948-300x165.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-1-9885948-1024x564.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-1-9885948-768x423.png 768w' sizes='(max-width: 1118px) 100vw, 1118px'\/><\/noscript><\/figure>\n<p>Wenn Sie sich auf der Power BI-Ansichtsseite befinden. Klicken Sie auf der Registerkarte Start auf <b>Informationen bekommen<\/b> Option und w\u00e4hlen Sie die <b>Herausragend,<\/b> wie wir unten gezeigt haben. Oder w\u00e4hlen Sie <b>Mehr sehen<\/b> Optionen und w\u00e4hlen Sie <b>Herausragend<\/b>.<\/p>\n<figure class=\"wp-block-image\"><img alt='Connect-Power-Bi-to-Multiple-Excel-Sheets-2-8961161' width='1037' height='594' class=\"wp-image-30228\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-2-8961161.png 1037w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-2-8961161-300x172.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-2-8961161-1024x587.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-2-8961161-768x440.png 768w' data-lazy-sizes='(max-width: 1037px) 100vw, 1037px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-2-8961161.png'\/><noscript><img alt='Connect-Power-Bi-to-Multiple-Excel-Sheets-2-8961161' width='1037' height='594' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-2-8961161.png' class=\"wp-image-30228\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-2-8961161.png 1037w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-2-8961161-300x172.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-2-8961161-1024x587.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-2-8961161-768x440.png 768w' sizes='(max-width: 1037px) 100vw, 1037px'\/><\/noscript><\/figure>\n<p>Sobald Sie auf das klicken <b>Herausragend<\/b> Auf der Registerkarte wird ein neues Fenster ge\u00f6ffnet, in dem Sie die Excel-Datei aus unserem Dateisystem ausw\u00e4hlen k\u00f6nnen. Im Moment w\u00e4hlen wir die Sample - Superstore-Datei aus, wie unten gezeigt.<\/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='Connect-Power-Bi-to-Multiple-Excel-Sheets-3-8028849' width='703' height='439' class=\"wp-image-30229\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-3-8028849.png 703w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-3-8028849-300x187.png 300w' data-lazy-sizes='(max-width: 703px) 100vw, 703px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-3-8028849.png'\/><noscript><img alt='Connect-Power-Bi-to-Multiple-Excel-Sheets-3-8028849' width='703' height='439' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-3-8028849.png' class=\"wp-image-30229\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-3-8028849.png 703w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-3-8028849-300x187.png 300w' sizes='(max-width: 703px) 100vw, 703px'\/><\/noscript><\/figure>\n<p>Durch Erweitern des Superstore Excel-Ordners wird die Liste der verf\u00fcgbaren Bl\u00e4tter angezeigt.<\/p>\n<figure class=\"wp-block-image\"><img alt='Connect-Power-Bi-to-Multiple-Excel-Sheets-4-1375595' width='716' height='488' class=\"wp-image-30230\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-4-1375595.png 716w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-4-1375595-300x204.png 300w' data-lazy-sizes='(max-width: 716px) 100vw, 716px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-4-1375595.png'\/><noscript><img alt='Connect-Power-Bi-to-Multiple-Excel-Sheets-4-1375595' width='716' height='488' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-4-1375595.png' class=\"wp-image-30230\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-4-1375595.png 716w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-4-1375595-300x204.png 300w' sizes='(max-width: 716px) 100vw, 716px'\/><\/noscript><\/figure>\n<p>Wenn Sie das Blatt oder die Tabelle ausw\u00e4hlen, wird die Datenvorschau angezeigt. Im folgenden Screenshot sehen Sie die Vorschau des Blattes. Wenn Sie mit den Daten und Datentypen zufrieden sind, klicken Sie auf die Schaltfl\u00e4che Hochladen. Andernfalls klicken Sie auf die Schaltfl\u00e4che Bearbeiten, um \u00c4nderungen vorzunehmen.<\/p>\n<p>Derzeit m\u00f6chten wir keine \u00c4nderungen an den Daten vornehmen. Also lass mich auf klicken <strong>Belastung<\/strong> Taste<\/p>\n<figure class=\"wp-block-image\"><img alt='Connect-Power-Bi-to-Multiple-Excel-Sheets-5-7776458' width='971' height='552' class=\"wp-image-30231\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-5-7776458.png 971w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-5-7776458-300x171.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-5-7776458-768x437.png 768w' data-lazy-sizes='(max-width: 971px) 100vw, 971px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-5-7776458.png'\/><noscript><img alt='Connect-Power-Bi-to-Multiple-Excel-Sheets-5-7776458' width='971' height='552' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-5-7776458.png' class=\"wp-image-30231\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-5-7776458.png 971w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-5-7776458-300x171.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-5-7776458-768x437.png 768w' sizes='(max-width: 971px) 100vw, 971px'\/><\/noscript><\/figure>\n<p>Bitte warten Sie, bis der Upload abgeschlossen ist<\/p>\n<figure class=\"wp-block-image\"><img alt='Connect-Power-Bi-to-Multiple-Excel-Sheets-6-8406724' width='500' height='335' class=\"wp-image-30232\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-6-8406724.png 500w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-6-8406724-300x201.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-6-8406724-400x269.png 400w' data-lazy-sizes='(max-width: 500px) 100vw, 500px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-6-8406724.png'\/><noscript><img alt='Connect-Power-Bi-to-Multiple-Excel-Sheets-6-8406724' width='500' height='335' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-6-8406724.png' class=\"wp-image-30232\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-6-8406724.png 500w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-6-8406724-300x201.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-6-8406724-400x269.png 400w' sizes='(max-width: 500px) 100vw, 500px'\/><\/noscript><\/figure>\n<p>Jetzt k\u00f6nnen Sie alle aus der Excel-Datei importierten Spalten in der <strong>Felder<\/strong> Sektion. Wie Sie sehen, liegt ein Problem mit der Benutzertabelle vor, da Power BI die Spaltennamen in der ersten Zeile nicht ausgew\u00e4hlt hat.<\/p>\n<figure class=\"wp-block-image\"><img alt='Connect-Power-Bi-to-Multiple-Excel-Sheets-7-8336661' width='1017' height='589' class=\"wp-image-30233\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-7-8336661.png 1017w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-7-8336661-300x174.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-7-8336661-768x445.png 768w' data-lazy-sizes='(max-width: 1017px) 100vw, 1017px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-7-8336661.png'\/><noscript><img alt='Connect-Power-Bi-to-Multiple-Excel-Sheets-7-8336661' width='1017' height='589' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-7-8336661.png' class=\"wp-image-30233\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-7-8336661.png 1017w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-7-8336661-300x174.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-7-8336661-768x445.png 768w' sizes='(max-width: 1017px) 100vw, 1017px'\/><\/noscript><\/figure>\n<p>Klicke auf das <strong>Abfragen bearbeiten<\/strong> Zunge<\/p>\n<figure class=\"wp-block-image\"><img alt='Connect-Power-Bi-to-Multiple-Excel-Sheets-8-1703007' width='1018' height='588' class=\"wp-image-30234\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-8-1703007.png 1018w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-8-1703007-300x173.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-8-1703007-768x444.png 768w' data-lazy-sizes='(max-width: 1018px) 100vw, 1018px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-8-1703007.png'\/><noscript><img alt='Connect-Power-Bi-to-Multiple-Excel-Sheets-8-1703007' width='1018' height='588' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-8-1703007.png' class=\"wp-image-30234\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-8-1703007.png 1018w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-8-1703007-300x173.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-8-1703007-768x444.png 768w' sizes='(max-width: 1018px) 100vw, 1018px'\/><\/noscript><\/figure>\n<p>Klicke auf das <strong>Verwenden Sie die erste Zeile als \u00dcberschriften<\/strong><\/p>\n<figure class=\"wp-block-image\"><img alt='Connect-Power-Bi-to-Multiple-Excel-Sheets-9-4147248' width='1022' height='587' class=\"wp-image-30235\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-9-4147248.png 1022w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-9-4147248-300x172.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-9-4147248-768x441.png 768w' data-lazy-sizes='(max-width: 1022px) 100vw, 1022px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-9-4147248.png'\/><noscript><img alt='Connect-Power-Bi-to-Multiple-Excel-Sheets-9-4147248' width='1022' height='587' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-9-4147248.png' class=\"wp-image-30235\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-9-4147248.png 1022w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-9-4147248-300x172.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-9-4147248-768x441.png 768w' sizes='(max-width: 1022px) 100vw, 1022px'\/><\/noscript><\/figure>\n<p>Das ist es. Wir verbinden Power BI mit mehreren Excel-Tabellen und laden Daten aus mehreren Tabellen.<\/p>\n<p>Lassen Sie mich mit diesen Daten ein S\u00e4ulendiagramm erstellen. Ich empfehle Ihnen, das S\u00e4ulendiagramm im Power BI-Artikel zu lesen, um die zum Erstellen erforderlichen Schritte zu verstehen.<\/p>\n<figure class=\"wp-block-image\"><img alt='Connect-Power-Bi-to-Multiple-Excel-Sheets-10-4470759' width='1355' height='755' class=\"wp-image-30236\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-10-4470759.png 1355w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-10-4470759-300x167.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-10-4470759-1024x571.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-10-4470759-768x428.png 768w' data-lazy-sizes='(max-width: 1355px) 100vw, 1355px' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-10-4470759.png'\/><noscript><img alt='Connect-Power-Bi-to-Multiple-Excel-Sheets-10-4470759' width='1355' height='755' src='https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-10-4470759.png' class=\"wp-image-30236\" srcset='\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-10-4470759.png 1355w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-10-4470759-300x167.png 300w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-10-4470759-1024x571.png 1024w, \/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-10-4470759-768x428.png 768w' sizes='(max-width: 1355px) 100vw, 1355px'\/><\/noscript><\/figure>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>In diesem Artikel zeigen wir Ihnen, wie Sie Power BI mit mehreren Excel-Tabellen verbinden und wie Sie die in diesen Excel-Tabellen vorhandenen Daten nutzen. Um den Zusammenhang von\u2026 zu demonstrieren<\/p>","protected":false},"author":1,"featured_media":85387,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1359,1360],"tags":[],"class_list":["post-85386","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>Conecte Power BI a varias hojas de Excel - R Marketing Digital<\/title>\n<meta name=\"description\" content=\"En este art\u00edculo, le mostramos c\u00f3mo conectar Power BI a varias hojas de Excel y c\u00f3mo usar los datos presentes en esas hojas de Excel. Para demostrar la\" \/>\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\/conecte-power-bi-a-varias-hojas-de-excel\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Conecte Power BI a varias hojas de Excel\" \/>\n<meta property=\"og:description\" content=\"En este art\u00edculo, le mostramos c\u00f3mo conectar Power BI a varias hojas de Excel y c\u00f3mo usar los datos presentes en esas hojas de Excel. Para demostrar la\" \/>\n<meta property=\"og:url\" content=\"https:\/\/rmarketingdigital.com\/de\/energiebi\/conecte-power-bi-a-varias-hojas-de-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"R Marketing Digital\" \/>\n<meta property=\"article:published_time\" content=\"2022-10-06T13:31:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-5-3315242.png\" \/>\n\t<meta property=\"og:image:width\" content=\"971\" \/>\n\t<meta property=\"og:image:height\" content=\"552\" \/>\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\\\/conecte-power-bi-a-varias-hojas-de-excel\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/conecte-power-bi-a-varias-hojas-de-excel\\\/\"},\"author\":{\"name\":\"R Marketing Digital\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#\\\/schema\\\/person\\\/7c0d9782b2977b840b3740f00c69a73e\"},\"headline\":\"Conecte Power BI a varias hojas de Excel\",\"datePublished\":\"2022-10-06T13:31:04+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/conecte-power-bi-a-varias-hojas-de-excel\\\/\"},\"wordCount\":413,\"image\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/conecte-power-bi-a-varias-hojas-de-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/rmarketingdigital.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/Connect-Power-BI-to-Multiple-Excel-Sheets-5-3315242.png\",\"articleSection\":[\"Power BI\",\"Tutoriales PowerBI\"],\"inLanguage\":\"de\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/conecte-power-bi-a-varias-hojas-de-excel\\\/\",\"url\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/conecte-power-bi-a-varias-hojas-de-excel\\\/\",\"name\":\"Conecte Power BI a varias hojas de Excel - R Marketing Digital\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/conecte-power-bi-a-varias-hojas-de-excel\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/conecte-power-bi-a-varias-hojas-de-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/rmarketingdigital.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/Connect-Power-BI-to-Multiple-Excel-Sheets-5-3315242.png\",\"datePublished\":\"2022-10-06T13:31:04+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/#\\\/schema\\\/person\\\/7c0d9782b2977b840b3740f00c69a73e\"},\"description\":\"En este art\u00edculo, le mostramos c\u00f3mo conectar Power BI a varias hojas de Excel y c\u00f3mo usar los datos presentes en esas hojas de Excel. Para demostrar la\",\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/conecte-power-bi-a-varias-hojas-de-excel\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/conecte-power-bi-a-varias-hojas-de-excel\\\/#primaryimage\",\"url\":\"https:\\\/\\\/rmarketingdigital.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/Connect-Power-BI-to-Multiple-Excel-Sheets-5-3315242.png\",\"contentUrl\":\"https:\\\/\\\/rmarketingdigital.com\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/Connect-Power-BI-to-Multiple-Excel-Sheets-5-3315242.png\",\"width\":971,\"height\":552,\"caption\":\"connect-power-bi-to-multiple-excel-sheets-5-3315242-8879513-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":"Verbinden Sie Power BI mit mehreren Excel-Tabellen - R Marketing Digital","description":"In diesem Artikel zeigen wir Ihnen, wie Sie Power BI mit mehreren Excel-Tabellen verbinden und die in diesen Excel-Tabellen enthaltenen Daten verwenden. Um das zu demonstrieren","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\/conecte-power-bi-a-varias-hojas-de-excel\/","og_locale":"de_DE","og_type":"article","og_title":"Conecte Power BI a varias hojas de Excel","og_description":"En este art\u00edculo, le mostramos c\u00f3mo conectar Power BI a varias hojas de Excel y c\u00f3mo usar los datos presentes en esas hojas de Excel. Para demostrar la","og_url":"https:\/\/rmarketingdigital.com\/de\/energiebi\/conecte-power-bi-a-varias-hojas-de-excel\/","og_site_name":"R Marketing Digital","article_published_time":"2022-10-06T13:31:04+00:00","og_image":[{"width":971,"height":552,"url":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-5-3315242.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\/conecte-power-bi-a-varias-hojas-de-excel\/#article","isPartOf":{"@id":"https:\/\/rmarketingdigital.com\/powerbi\/conecte-power-bi-a-varias-hojas-de-excel\/"},"author":{"name":"R Marketing Digital","@id":"https:\/\/rmarketingdigital.com\/#\/schema\/person\/7c0d9782b2977b840b3740f00c69a73e"},"headline":"Conecte Power BI a varias hojas de Excel","datePublished":"2022-10-06T13:31:04+00:00","mainEntityOfPage":{"@id":"https:\/\/rmarketingdigital.com\/powerbi\/conecte-power-bi-a-varias-hojas-de-excel\/"},"wordCount":413,"image":{"@id":"https:\/\/rmarketingdigital.com\/powerbi\/conecte-power-bi-a-varias-hojas-de-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-5-3315242.png","articleSection":["Power BI","Tutoriales PowerBI"],"inLanguage":"de"},{"@type":"WebPage","@id":"https:\/\/rmarketingdigital.com\/powerbi\/conecte-power-bi-a-varias-hojas-de-excel\/","url":"https:\/\/rmarketingdigital.com\/powerbi\/conecte-power-bi-a-varias-hojas-de-excel\/","name":"Verbinden Sie Power BI mit mehreren Excel-Tabellen - R Marketing Digital","isPartOf":{"@id":"https:\/\/rmarketingdigital.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/rmarketingdigital.com\/powerbi\/conecte-power-bi-a-varias-hojas-de-excel\/#primaryimage"},"image":{"@id":"https:\/\/rmarketingdigital.com\/powerbi\/conecte-power-bi-a-varias-hojas-de-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-5-3315242.png","datePublished":"2022-10-06T13:31:04+00:00","author":{"@id":"https:\/\/rmarketingdigital.com\/#\/schema\/person\/7c0d9782b2977b840b3740f00c69a73e"},"description":"In diesem Artikel zeigen wir Ihnen, wie Sie Power BI mit mehreren Excel-Tabellen verbinden und die in diesen Excel-Tabellen enthaltenen Daten verwenden. Um das zu demonstrieren","inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/rmarketingdigital.com\/powerbi\/conecte-power-bi-a-varias-hojas-de-excel\/"]}]},{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/rmarketingdigital.com\/powerbi\/conecte-power-bi-a-varias-hojas-de-excel\/#primaryimage","url":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-5-3315242.png","contentUrl":"https:\/\/rmarketingdigital.com\/wp-content\/uploads\/2020\/09\/Connect-Power-BI-to-Multiple-Excel-Sheets-5-3315242.png","width":971,"height":552,"caption":"connect-power-bi-to-multiple-excel-sheets-5-3315242-8879513-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\/85386","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=85386"}],"version-history":[{"count":0,"href":"https:\/\/rmarketingdigital.com\/de\/wp-json\/wp\/v2\/posts\/85386\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/rmarketingdigital.com\/de\/wp-json\/wp\/v2\/media\/85387"}],"wp:attachment":[{"href":"https:\/\/rmarketingdigital.com\/de\/wp-json\/wp\/v2\/media?parent=85386"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rmarketingdigital.com\/de\/wp-json\/wp\/v2\/categories?post=85386"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rmarketingdigital.com\/de\/wp-json\/wp\/v2\/tags?post=85386"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}