Track your progress and stay up-to-date

By clicking Track progress, you are giving your consent to Microsoft to provide you updates about Power BI learning resources via email. You can unsubscribe at any time.

×

Great! You finished your first topic!

Enter your email to track your progress and stay up-to-date on new Power BI learning content.

By clicking Track progress, you are giving your consent to Microsoft to provide you updates about Power BI learning resources via email. You can unsubscribe at any time.

×

Thanks!

As you progress through Guided Learning, a green checkmark will appear next to your completed topics.

×

You’ve mastered the building blocks

With an introduction complete, get ready to dive deep!

Power BI and Excel

Next Topic

Import an Excel table into Power BI

Continue

Watch Again

Welcome to the Power BI and Excel section of the Guided Learning course for Power BI.

Chances are good that you've used Excel before. Maybe you used Excel to create or view reports, or to build pie charts or other visuals. Or maybe you used Power Pivot or Power Query to build solutions that were a bit more technical. If so, you'll be right at home in Power BI, and so will your workbooks.

This section shows you just how easy it is to bring Excel workbooks into Power BI, and demonstrates that Power BI and Excel make a great partnership.

Introduction to Using Excel Data in Power BI

Watch an introduction to the ways Excel and the Power BI service work together

With Power BI, getting your Excel data into Power BI is easy.

The following topics guide you through uploading an Excel workbook with a simple table into Power BI. Then you see how to upload workbooks created with Excel's more advanced BI data modeling and reporting features, such as Power Pivot and Power View.

You'll also learn some benefits of saving your Excel workbook files to OneDrive for Business. When you connect to Excel files on OneDrive from Power BI, your reports and dashboards in Power BI are updated and refreshed automatically when you make changes and save your work.

Request demo