Six ways Excel users save time with Power BI

Excel is a powerful, flexible tool for every analytics activity. Combine it with Power BI to get broad data analytics and visualisation capabilities. Easily gather, shape, analyse, and explore key business data in new ways—all in less time—using both apps together.


Get powerful new capabilities—using the skills you already have

Quickly start creating stunning interactive dashboards by easily transferring all of your current Excel queries, data models, and reports to Power BI—without learning a new application or language.

Automate your data refresh with one click

Get the right data instantly when you open your dashboard—without having to take any additional action. Set your Power Pivot data to refresh manually or automatically at any frequency you choose.

Use and share multiple workbooks in a single view

Display ranges of data, charts, and tables on a Power BI dashboard—combining data from multiple sources—by connecting your Excel workbooks to Power BI.

Get self-service data visualisation

Get rich, interactive visualisations and the ability to query by asking natural language questions by extending your Excel data models to your Power BI reports. Empower colleagues of varying ability and experience levels—even Excel novices—to understand your insights and discover their own.

Add advanced analytics to your models

Get advanced custom visualisation, modelling, and predictive capabilities for advanced analytics workflows in Power BI by running R scripts and using R-powered custom visuals.

Maintain the flexibility of the grid

Easily work with Power BI data in Excel for ad-hoc analysis. With a single click, connect to your data models directly from Excel to create powerful PivotTables and charts.

Get started in three steps

1. Download Power BI Desktop

Create stunning interactive reports by connecting to your Excel data. Tell your data story using a drag-and-drop canvas with more than 85 modern data visuals.

2. Get a Power BI trial

Share and distribute reports with others—without any complicated setup—using Power BI Pro. Get a 360-degree view of your business in one place, including Excel reports and objects.

3. Analyse Power BI data with Excel tools

View and work with your Power BI datasets in Excel using the Analyse in Excel feature. Gain insights on your data using Excel tools like PivotTables, charts, and slicers—all within Power BI.