All courses available in-class or via remote login

Excel into Power BI Nexacu

Importing Excel workbooks into Power BI

August 12, 2020


Microsoft Excel
remains a vital tool for organisations and essential for reporting, calculating and sharing data. However with Business Intelligence and data analysis becoming increasingly valuable, it’s important that Excel spreadsheets are integrated into a business analysis tool like Power BI so that organisations can visualise and interpret their data more effectively. Not only can you can you capture the raw data from the spreadsheet but Power BI can also capture Power Pivot tables, Power View visualisations and Power Queries.

With Power BI Desktop, importing Excel spreadsheets is easy. Power BI automatically creates reports and visualisations of the data contained in the workbook. Once your data has been imported, you can then continue to improve your reports and visualisations using the existing features within Power BI.

For more information about our Power BI courses click here.

This blog will look at how to import an Excel workbook into Power BI.


1. In Power BI, click FileImport > Power Query, Power Pivot, Power View.





2. From the Open window, select an Excel workbook to import. (the larger the file the longer it will take for Power BI to import and analyse)


3. From the import dialog box that appears, select Start.

Power BI will analyse the workbook and convert it to a Power BI Desktop file. This can then be used with no requirement for the original Excel file. It can be saved, edited and shared without affecting the original workbook.




After the import has finished Power BI will display a summary page that outline which items were converted and if there were any errors in the upload.

 

4. Select Close.





Power BI Desktop loads a report based on the workbook contents, which you can continue to edit, create new visualisations, add data or create new reports.

Contact Us

What is Remote Training?

Valued by Individuals

4.8/5
Over 25917 Reviews
Great context set up for the course and great presentation by Steven! It helped me to refresh some already used functions and learn new functions that beneficial to my work. Thank you! -Excel Advanced Brisbane
Lu - Excel Advanced, .
Great course, was well paced for my skill level. Stephen is a great trainer, knowledgeable, easy to follow, and easy to listen to. -Excel Advanced Brisbane
Beth - Excel Advanced, .
Steve has once again proved to be an excellent trainer. I appreciated his personal attention to questions and issues raised. He also took the time to investigate additional topics that were beyond the set scope of the course. Great learning experience! -Excel Advanced Brisbane
Cindy - Excel Advanced, .
Very informative training! I feel like I have learnt a lot. Very engaging trainer! :) -Excel Advanced Brisbane
Alexandra - Excel Advanced, .
The training was well presented. Learning more about relative and absolute was great. Working in charts and learning more about trends and forecasting was very helpful. -Excel Beginner Brisbane
Annette - Excel Beginner, .
Course is well structured and presenter very knowledgeable -Excel Beginner Brisbane
Kevin - Excel Beginner, .
Good presentation and educational. -Excel Beginner Brisbane
Wayne - Excel Beginner, .
Wonderful course. Learnt a lot from an extremely knowledgeable instructor. Thank you! -Excel Beginner Brisbane
Emma - Excel Beginner, .
It was good to increase my efficiency using Excel. -Excel Beginner Brisbane
Nathan - Excel Beginner, .
it was a great training session -Excel Beginner Brisbane
Belinda - Excel Beginner, .
Great course, I learnt a lot and have taken away some skills i can use in my workplace. -Excel Beginner Brisbane
Chantelle - Excel Beginner, .
Very informative. Well paced session. Clear instruction. Good foundation of learning. Thank you. -Excel Beginner Brisbane
Hayley - Excel Beginner, .
Even though the session was remote , It was interesting. I really learned lots of tips & shortcuts that could be used in my role . Overall the session was all good. Great session Ken!!! -Excel Customised Melbourne
Shoma - Excel Customised, .
It was quite a good session for me. Pivot Tables & Macros were the two components that I was really interested in, and Ken was marvelous in teaching those. Also there were few major shortcuts which I never knew before, so it was really awesome to know these -Excel Customised Melbourne
Abdul - Excel Customised, .
Good Handy Tips and Tricks. -Excel Customised Melbourne
William - Excel Customised, .
Ken is great, it was easy to understand, his speed was easy to follow. -Excel Customised Melbourne
Selina - Excel Customised, .
Ken was great! Lots of knowledge and went at a great pace. Thanks Ken! -Excel Customised Melbourne
Lely - Excel Customised, .
It was a good session. -Power BI Advanced Melbourne
Ehsan - Power BI Advanced, .
Very good -Power BI Advanced Melbourne
Vinh - Power BI Advanced, .
Was very useful and learnt a lot of new concepts. -Power BI Intermediate Perth
Karthik - Power BI Intermediate, .

Trusted by Business

Procured by Government

Awards and Accreditations

Map of Australia

Follow us