{"id":22180,"date":"2018-08-01T03:45:36","date_gmt":"2018-08-01T03:45:36","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=22180"},"modified":"2018-09-11T21:47:41","modified_gmt":"2018-09-11T16:17:41","slug":"excel-workbooks-into-power-bi","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/excel-workbooks-into-power-bi\/","title":{"rendered":"Importing Excel Workbooks into Power BI Desktop in 5 Min"},"content":{"rendered":"<div class='__iawmlf-post-loop-links' style='display:none;' data-iawmlf-post-links='[{&quot;id&quot;:1847,&quot;href&quot;:&quot;https:\\\/\\\/docs.microsoft.com\\\/en-us\\\/power-bi\\\/desktop-import-excel-workbooks&quot;,&quot;archived_href&quot;:&quot;http:\\\/\\\/web-wp.archive.org\\\/web\\\/20190831010812\\\/https:\\\/\\\/docs.microsoft.com\\\/en-us\\\/power-bi\\\/desktop-import-excel-workbooks&quot;,&quot;redirect_href&quot;:&quot;https:\\\/\\\/learn.microsoft.com\\\/en-us\\\/power-bi\\\/desktop-import-excel-workbooks&quot;,&quot;checks&quot;:[{&quot;date&quot;:&quot;2025-12-11 04:11:55&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2025-12-29 18:08:47&quot;,&quot;http_code&quot;:404},{&quot;date&quot;:&quot;2026-01-05 07:39:13&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-14 04:58:09&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-28 02:06:46&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-06 14:04:17&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-13 20:08:34&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-22 17:51:50&quot;,&quot;http_code&quot;:206}],&quot;broken&quot;:false,&quot;last_checked&quot;:{&quot;date&quot;:&quot;2026-05-22 17:51:50&quot;,&quot;http_code&quot;:206},&quot;process&quot;:&quot;done&quot;}]'><\/div>\n<h2 class=\"western\">1. Objective<\/h2>\n<p>In our last tutorial, we discuss\u00a0<a href=\"https:\/\/data-flair.training\/blogs\/power-bi-bookmark\/\"><strong>Power BI Bookmark<\/strong><\/a>. Here, in this Power BI tutorial, we will learn How can we Import Excel workbooks into <strong><a href=\"https:\/\/data-flair.training\/blogs\/power-bi-tutorial\/\">Power BI<\/a><\/strong> Desktop Manually. Moreover, we will discuss which Excel Workbook is manual components foreign and problems at the time of importing Excel workbooks into Power BI Desktop.<br \/>\nSo, let&#8217;s start the importing\u00a0Excel Workbooks into Power BI Desktop.<\/p>\n<div id=\"attachment_22213\" style=\"width: 1210px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Importing-Excel-Workbooks-into-Power-BI-Desktop-01.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-22213\" class=\"wp-image-22213 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Importing-Excel-Workbooks-into-Power-BI-Desktop-01.jpg\" alt=\"Importing Excel Workbooks into Power BI Desktop\" width=\"1200\" height=\"628\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Importing-Excel-Workbooks-into-Power-BI-Desktop-01.jpg 1200w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Importing-Excel-Workbooks-into-Power-BI-Desktop-01-150x79.jpg 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Importing-Excel-Workbooks-into-Power-BI-Desktop-01-300x157.jpg 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Importing-Excel-Workbooks-into-Power-BI-Desktop-01-768x402.jpg 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Importing-Excel-Workbooks-into-Power-BI-Desktop-01-1024x536.jpg 1024w\" sizes=\"auto, (max-width: 1200px) 100vw, 1200px\" \/><\/a><p id=\"caption-attachment-22213\" class=\"wp-caption-text\">Importing Excel Workbooks into Power BI Desktop<\/p><\/div>\n<h2>2. How Can We Import Excel Workbooks into Power BI Desktop?<\/h2>\n<p>With Power BI Desktop, you can without much of a stretch import Excel exercise manuals that contain Power Query questions, Power Pivot models, and Power View worksheets into Power BI Desktop. Reports and representations are naturally made in view of the Excel exercise manual, and once transported in, you can proceed to enhance and refine those reports utilizing Power BI Desktop, utilizing the current highlights and new highlights discharged with each Power BI Desktop month to month refresh.<br \/>\n<strong><a href=\"https:\/\/data-flair.training\/blogs\/power-bi-dashboard\/\">Do you know How to Create Power BI Dashboard with Example\u00a0<\/a><\/strong><br \/>\nLater on, the arrangement is to give extra correspondence amongst Excel and Power BI Desktop, <strong>(for example, import\/trade)<\/strong>; this present capacity to import exercise manuals into Power BI Desktop lets existing Excel clients begin with Power BI Desktop.<\/p>\n<h2>3. How would We Import an Excel Sheet into Power BI (manually)?<\/h2>\n<p>To import an Excel\u00a0Workbook into Power Bi Desktop manually, from Power BI Desktop select <strong>File &#8211; &gt; Import &#8211; &gt; Excel Workbook Contents<\/strong>.<\/p>\n<div id=\"attachment_22204\" style=\"width: 683px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/importexceltopbi_1.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-22204\" class=\"wp-image-22204 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/importexceltopbi_1.png\" alt=\"Importing Excel Workbooks into Power BI Desktop\" width=\"673\" height=\"706\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/importexceltopbi_1.png 673w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/importexceltopbi_1-143x150.png 143w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/importexceltopbi_1-286x300.png 286w\" sizes=\"auto, (max-width: 673px) 100vw, 673px\" \/><\/a><p id=\"caption-attachment-22204\" class=\"wp-caption-text\">Step-1 To Import Excel Workbooks into Power BI Desktop<\/p><\/div>\n<p>A window shows up, giving you a chance to choose the exercise manual to import. There is right now no confinement on the size or number of items in the exercise manual, however bigger exercise manuals take more time for Power BI Desktop to break down and import.<br \/>\n<b>Note &#8211;\u00a0<\/b>To load or import Excel documents from shared OneDrive for Business organizers or from Office 365 gathering envelopes, utilize the URL of the Excel record, and info it into the Web information source in Power BI Desktop. There are a couple of steps you have to take after to appropriately design the OneDrive for Business URL. So look at use OneDrive for Business interfaces in Power BI Desktop for more data and the right arrangement of steps.<br \/>\nOnce an exercise manual is chosen, Power BI Desktop breaks down the exercise manual and proselytes it into a Power BI Desktop document (.pbix). This activity is a one-time occasion; once the Power BI Desktop record is made with these means, the Power BI Desktop document has no reliance on the first Excel exercise manual and can be adjusted or changed (and spared, and shared) without influencing the first exercise manual.<br \/>\n<strong><a href=\"https:\/\/data-flair.training\/blogs\/workspace-in-power-bi\/\">Let&#8217;s Explore How to Create Workspace in Power BI<\/a><\/strong><\/p>\n<div id=\"attachment_22205\" style=\"width: 531px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/importexceltopbi_2.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-22205\" class=\"wp-image-22205 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/importexceltopbi_2.png\" alt=\"Importing Excel Workbooks into Power BI Desktop\" width=\"521\" height=\"390\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/importexceltopbi_2.png 521w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/importexceltopbi_2-150x112.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/importexceltopbi_2-300x225.png 300w\" sizes=\"auto, (max-width: 521px) 100vw, 521px\" \/><\/a><p id=\"caption-attachment-22205\" class=\"wp-caption-text\">Step-2 To Import Excel Workbooks into Power BI Desktop<\/p><\/div>\n<p>Once the import is done, a Summary page is shown that depicts the things that were changed over, and furthermore records any things that were not ready to be foreign.<\/p>\n<div id=\"attachment_22206\" style=\"width: 531px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/importexceltopbi_3.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-22206\" class=\"wp-image-22206 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/importexceltopbi_3.png\" alt=\"Importing Excel Workbooks into Power BI Desktop\" width=\"521\" height=\"390\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/importexceltopbi_3.png 521w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/importexceltopbi_3-150x112.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/importexceltopbi_3-300x225.png 300w\" sizes=\"auto, (max-width: 521px) 100vw, 521px\" \/><\/a><p id=\"caption-attachment-22206\" class=\"wp-caption-text\">Step- 3 To Import Excel Workbooks into Power BI Desktop<\/p><\/div>\n<p>When you select Close, the report is stacked in Power BI Desktop. The accompanying picture demonstrates Power BI Desktop after an Excel exercise manual was foreign made: Power BI Desktop naturally stacked the report in view of the exercise manual substance.<\/p>\n<div id=\"attachment_22207\" style=\"width: 1013px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/importexceltopbi_4.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-22207\" class=\"wp-image-22207 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/importexceltopbi_4.png\" alt=\"Importing Excel Workbooks into Power BI Desktop\" width=\"1003\" height=\"666\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/importexceltopbi_4.png 1003w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/importexceltopbi_4-150x100.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/importexceltopbi_4-300x199.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/importexceltopbi_4-768x510.png 768w\" sizes=\"auto, (max-width: 1003px) 100vw, 1003px\" \/><\/a><p id=\"caption-attachment-22207\" class=\"wp-caption-text\">Step- 4 To Import Excel Workbooks into Power BI Desktop<\/p><\/div>\n<p>Since the exercise manual is transported in, you can keep chipping away at the report \u2013 for example, making new perceptions, including information, or make new report pages \u2013 utilizing any of the highlights and abilities incorporated into Power BI Desktop.<br \/>\n<strong><a href=\"https:\/\/data-flair.training\/blogs\/power-bi-view-dashboard\/\">Read about Power Bi View Dashboard &amp; Report on Mobile, Tab, PC<\/a><\/strong><\/p>\n<h2>4. Which Exercise are Manual Components Foreign?<\/h2>\n<p>Power BI Work area can import the accompanying components, usually alluded to as items, to exceed expectations.<\/p>\n<h3>a.\u00a0Power Inquiry Queries<\/h3>\n<p>All Power Question inquiries from exceed expectations change over to inquiries in Power BI Work area. In the event that there were Inquiry Gatherings characterized in the Exceed expectations Exercise manual, a similar association will reproduce in the Power BI Work area. All questions stakes except if they were set to &#8220;Just Make Association&#8221; in Exceed\u00a0expectations. The Heap conduct can redo from the Properties exchange in the Home tab of Inquiry Editorial manager in Power BI Work area.<\/p>\n<h3>b. Power Turn Outside Information Connections<\/h3>\n<p>All Power Rotate Outer Information Associations will change over to inquiries in Power BI Work area.<\/p>\n<h3>c.\u00a0Connected Tables or Current Exercise Manual Tables<\/h3>\n<p>If there is a worksheet table in Exceed expectations connects to the Information Model or connects to an inquiry (by utilizing From Table or the Excel.CurrentWorkbook() work in M), the accompanying alternatives displays:<br \/>\n1. Import the table to the Power BI Work area document. This table is a one-time preview of the information, after which you can&#8217;t alter the information in the table in Power BI Work area. There is a size restriction of 1 million characters (add up to, consolidating all segment headers and cells) for tables made utilizing this alternative.<br \/>\n2. Keep an association with the first exercise manual. Then again, you can keep an association with the first Exceed expectations Exercise manual and Power BI Work area recovers the most recent substance in\u00a0this table with each revives, much the same as some other question made against an Exceed expectations exercise manual in Power BI Work area.<\/p>\n<h3>d. Information Show Ascertained Segments\u00a0and Others<\/h3>\n<p>These Information Display objects change over to the proportionate protests in Power BI Work area. Note there are sure Information Classifications that are not accessible in Power BI Work area, for example, Picture. In these cases, the Information Classification data will reset for the segments referring to.<\/p>\n<h3>e.\u00a0Power View Worksheets<\/h3>\n<p>A new report page makes for each Power View worksheet in Exceed expectations. The name and request of these report pages coordinate the first Exceed expectations exercise manual.<\/p>\n<h2>5. Constraints to Bringing in Excel Workbook Manual?<\/h2>\n<p>Following are the Problems faces, when we bring the excel workbook to Power BI.<br \/>\nThere are a couple of confinements to bringing in an exercise manual into Power BI Desktop, which is the accompanying rundown:<\/p>\n<h3>a. Outside Connections to Analysis Services Tabular Models<\/h3>\n<p>In Excel 2013, it is conceivable to make an association with SQL Server Analysis Services Tabular models and make Power View provides details regarding best of these models without the need to import the information. This sort of association is as of now not bolstered as a feature of bringing in Excel Workbooks into Power BI Desktop. As a workaround, you should reproduce these outer associations in Power BI Desktop.<\/p>\n<h3>b. Chains of command<\/h3>\n<p>This sort of Data Model protest is right now not bolstered in Power BI Desktop. In that capacity, orders skipped as a major aspect of bringing in an Excel Workbook into Power BI Desktop.<br \/>\n<strong><a href=\"https:\/\/data-flair.training\/blogs\/power-bi-and-excel\/\">Let&#8217;s discuss Power Bi and Excel Integration &#8211; With Existing Dashboard<\/a><\/strong><\/p>\n<h3>c. Twofold information sections<\/h3>\n<p>This sort of Data Model segment is right now not upheld in Power BI Desktop. Double Data segments expelled from the subsequent table in Power BI Desktop.<\/p>\n<h3>d. Unsupported Power View components<\/h3>\n<p>There are a couple of highlights in Power View that are not accessible in Power BI Desktop. For example, themes or certain sorts of representations. These unsupported perceptions result in Unsupported Visualization messages on their comparing areas in the Power BI Desktop report, which you can erase or reconfigure as required.<\/p>\n<h3>e. PowerPivot to SSRS<\/h3>\n<p>PowerPivot outside associations with SQL Server Reporting Services (SSRS) are not right now bolster. Since that information source isn&#8217;t presently accessible in Power BI Desktop.<br \/>\nSo, this was all about\u00a0How would we import an Excel Sheet into Power BI Tutorial. Hope you like our explanation.<\/p>\n<h2>6. Conclusion<\/h2>\n<p>Hence, in this Power BI tutorial, we learned how to import Excel workbook into Power BI, and the problems we faced. Furthermore, if you have any query, feel free to ask in the comment section.<br \/>\nRelated Topic &#8211;\u00a0<strong><a href=\"https:\/\/data-flair.training\/blogs\/power-bi-data-sources\/\">Power BI Data Sources <\/a><\/strong><br \/>\n<a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/desktop-import-excel-workbooks\"><strong>For reference<\/strong><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>1. Objective In our last tutorial, we discuss\u00a0Power BI Bookmark. Here, in this Power BI tutorial, we will learn How can we Import Excel workbooks into Power BI Desktop Manually. Moreover, we will discuss&#46;&#46;&#46;<\/p>\n","protected":false},"author":5,"featured_media":22213,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[42],"tags":[4424,4425,4426,6612,6613],"class_list":["post-22180","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-power-bi","tag-excel-sheet-to-power-bi","tag-excel-to-power-bi","tag-excel-workbook-to-power-bi","tag-import-pivot-table-into-power-bi","tag-import-power-query-into-power-bi"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Importing Excel Workbooks into Power BI Desktop in 5 Min - DataFlair<\/title>\n<meta name=\"description\" content=\"How to Import manually Excel Workbooks into Power BI Desktop, Transfer Excel Sheet into Power BI Desktop, Constraints to Bringing in Excel Workbook Manual\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/data-flair.training\/blogs\/excel-workbooks-into-power-bi\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Importing Excel Workbooks into Power BI Desktop in 5 Min - DataFlair\" \/>\n<meta property=\"og:description\" content=\"How to Import manually Excel Workbooks into Power BI Desktop, Transfer Excel Sheet into Power BI Desktop, Constraints to Bringing in Excel Workbook Manual\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/excel-workbooks-into-power-bi\/\" \/>\n<meta property=\"og:site_name\" content=\"DataFlair\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataFlairWS\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-08-01T03:45:36+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-09-11T16:17:41+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Importing-Excel-Workbooks-into-Power-BI-Desktop-01.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"DataFlair Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:site\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DataFlair Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Importing Excel Workbooks into Power BI Desktop in 5 Min - DataFlair","description":"How to Import manually Excel Workbooks into Power BI Desktop, Transfer Excel Sheet into Power BI Desktop, Constraints to Bringing in Excel Workbook Manual","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:\/\/data-flair.training\/blogs\/excel-workbooks-into-power-bi\/","og_locale":"en_US","og_type":"article","og_title":"Importing Excel Workbooks into Power BI Desktop in 5 Min - DataFlair","og_description":"How to Import manually Excel Workbooks into Power BI Desktop, Transfer Excel Sheet into Power BI Desktop, Constraints to Bringing in Excel Workbook Manual","og_url":"https:\/\/data-flair.training\/blogs\/excel-workbooks-into-power-bi\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-08-01T03:45:36+00:00","article_modified_time":"2018-09-11T16:17:41+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Importing-Excel-Workbooks-into-Power-BI-Desktop-01.jpg","type":"image\/jpeg"}],"author":"DataFlair Team","twitter_card":"summary_large_image","twitter_creator":"@DataFlairWS","twitter_site":"@DataFlairWS","twitter_misc":{"Written by":"DataFlair Team","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/excel-workbooks-into-power-bi\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/excel-workbooks-into-power-bi\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/7f83c342f5d1632d6f7b4b0b0f447823"},"headline":"Importing Excel Workbooks into Power BI Desktop in 5 Min","datePublished":"2018-08-01T03:45:36+00:00","dateModified":"2018-09-11T16:17:41+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/excel-workbooks-into-power-bi\/"},"wordCount":1378,"commentCount":0,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/excel-workbooks-into-power-bi\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Importing-Excel-Workbooks-into-Power-BI-Desktop-01.jpg","keywords":["Excel Sheet to Power BI","excel to power bi","Excel workbook to Power BI","import pivot table into power bi","import power query into power bi"],"articleSection":["Power BI Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/excel-workbooks-into-power-bi\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/excel-workbooks-into-power-bi\/","url":"https:\/\/data-flair.training\/blogs\/excel-workbooks-into-power-bi\/","name":"Importing Excel Workbooks into Power BI Desktop in 5 Min - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/excel-workbooks-into-power-bi\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/excel-workbooks-into-power-bi\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Importing-Excel-Workbooks-into-Power-BI-Desktop-01.jpg","datePublished":"2018-08-01T03:45:36+00:00","dateModified":"2018-09-11T16:17:41+00:00","description":"How to Import manually Excel Workbooks into Power BI Desktop, Transfer Excel Sheet into Power BI Desktop, Constraints to Bringing in Excel Workbook Manual","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/excel-workbooks-into-power-bi\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/excel-workbooks-into-power-bi\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/excel-workbooks-into-power-bi\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Importing-Excel-Workbooks-into-Power-BI-Desktop-01.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/07\/Importing-Excel-Workbooks-into-Power-BI-Desktop-01.jpg","width":1200,"height":628,"caption":"Importing Excel Workbooks into Power BI Desktop"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/excel-workbooks-into-power-bi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"SAS Foundation Tools Certifications","item":"https:\/\/data-flair.training\/blogs\/tag\/sas-foundation-tools-certifications\/"},{"@type":"ListItem","position":3,"name":"Importing Excel Workbooks into Power BI Desktop in 5 Min"}]},{"@type":"WebSite","@id":"https:\/\/data-flair.training\/blogs\/#website","url":"https:\/\/data-flair.training\/blogs\/","name":"DataFlair","description":"Learn Today. Lead Tomorrow.","publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/data-flair.training\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/data-flair.training\/blogs\/#organization","name":"DataFlair","url":"https:\/\/data-flair.training\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","width":106,"height":48,"caption":"DataFlair"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataFlairWS\/","https:\/\/x.com\/DataFlairWS","https:\/\/www.linkedin.com\/company\/dataflair-web-services-pvt-ltd\/","https:\/\/www.youtube.com\/user\/DataFlairWS"]},{"@type":"Person","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/7f83c342f5d1632d6f7b4b0b0f447823","name":"DataFlair Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/4cf3a74600d131330b8c481d519afd1574093ed89f6d3396a95393ad223eb7cd?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/4cf3a74600d131330b8c481d519afd1574093ed89f6d3396a95393ad223eb7cd?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4cf3a74600d131330b8c481d519afd1574093ed89f6d3396a95393ad223eb7cd?s=96&d=mm&r=g","caption":"DataFlair Team"},"description":"DataFlair Team creates expert-level guides on programming, Java, Python, C++, DSA, AI, ML, data Science, Android, Flutter, MERN, Web Development, and technology. Our goal is to empower learners with easy-to-understand content. Explore our resources for career growth and practical learning.","url":"https:\/\/data-flair.training\/blogs\/author\/dfteam1\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/22180","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/comments?post=22180"}],"version-history":[{"count":3,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/22180\/revisions"}],"predecessor-version":[{"id":32525,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/22180\/revisions\/32525"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/22213"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=22180"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=22180"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=22180"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}