{"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\/en\/powerbi\/conecte-power-bi-a-varias-hojas-de-excel\/","title":{"rendered":"Connect Power BI to multiple Excel sheets"},"content":{"rendered":"<div>\n<p>In this article, we show you how to connect Power BI to multiple Excel sheets and how to use the data present in those Excel sheets.<\/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>To demonstrate the Power BI connection to multiple Excel sheets, we will load data from multiple tables or sheets into an Excel file in Power BI and generate a bar chart.<\/p>\n<h2>How to connect Power BI to multiple Excel sheets<\/h2>\n<p>Before we start connecting Power BI to multiple Excel sheets, let&#039;s look at the data present in the sample superstore Excel file. In the following screenshot, you can see that you have three sheets Orders, Returns, and Users<\/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>If you&#039;re on the Power BI view page. On the Home tab, click the <b>Get information<\/b> option and select the <b>Standing out,<\/b> as we have shown below. Or select <b>More<\/b> options and select <b>Standing out<\/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>Once you click on the <b>Standing out<\/b> tab, a new window will open to select the Excel file from our file system. For now, we are selecting the Sample - Superstore file, as shown below.<\/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>Expanding the Superstore Excel folder will display the list of available sheets.<\/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>Selecting the sheet or table displays the Data Preview. In the screenshot below, you can see the preview of the sheet. If you are satisfied with the data and data types, click the Upload button; otherwise, click the Edit button to make changes.<\/p>\n<p>Currently, we do not want to make any changes to the data. So let me click on the <strong>Load<\/strong> button<\/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>Please wait until the upload is complete<\/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>Now you can see all the columns imported from the Excel file in the <strong>Fields<\/strong> section. As you can see, there is a problem with the Users table because Power BI didn&#039;t select the column names in the first row.<\/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>Click on the <strong>Edit queries<\/strong> tongue<\/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>Click on the <strong>Use the first row as headings<\/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>That&#039;s. We connect Power BI to multiple Excel sheets and load data from multiple sheets.<\/p>\n<p>Let me create a column chart with this data. I suggest you check out the Column Chart in Power BI article to understand the steps required to create it.<\/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 this article, we show you how to connect Power BI to multiple Excel sheets and how to use the data present in those Excel sheets. To demonstrate the connection of\u2026<\/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\/en\/powerbi\/conecte-power-bi-a-varias-hojas-de-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\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\/en\/powerbi\/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\":\"en-US\"},{\"@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\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/rmarketingdigital.com\\\/powerbi\\\/conecte-power-bi-a-varias-hojas-de-excel\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@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\":\"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":"Connect Power BI to multiple Excel sheets - R Marketing Digital","description":"In this article, we show you how to connect Power BI to multiple Excel sheets and how to use the data present in those Excel sheets. To demonstrate 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\/conecte-power-bi-a-varias-hojas-de-excel\/","og_locale":"en_US","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\/en\/powerbi\/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":"en-US"},{"@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":"Connect Power BI to multiple Excel sheets - 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 this article, we show you how to connect Power BI to multiple Excel sheets and how to use the data present in those Excel sheets. To demonstrate the","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/rmarketingdigital.com\/powerbi\/conecte-power-bi-a-varias-hojas-de-excel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@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 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\/85386","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=85386"}],"version-history":[{"count":0,"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/posts\/85386\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/media\/85387"}],"wp:attachment":[{"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/media?parent=85386"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/categories?post=85386"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rmarketingdigital.com\/en\/wp-json\/wp\/v2\/tags?post=85386"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}