Skip to main content
HomeAbout Power BILearn Power BI

How to Export Power BI Data to Excel

Wish you could see the data behind your Power BI visualizations? Here’s our guide to exporting Power BI data to Excel.
Aug 2022  · 6 min read

Power BI is one of the most widely used business intelligence tools today. Developed by Microsoft, Power BI lets you manage, analyze, and visualize huge amounts of data with no coding involved. Another key advantage of using Power BI is the ability for Excel experts to switch from Power BI to Excel and vice-versa. 

What are the different ways Power BI and Excel work with each other? In this tutorial, we'll explore common use cases of exporting Power BI data & reports into Excel. Let’s get started!

Common Use Cases of Exporting Power BI Data and Reports into Excel

There are a few reasons for which you would need to export data and reports from Power BI to Excel:

  • Analyzing the data in Excel: Even if Power BI has superior capabilities to Excel to store and process data, Excel can still be useful to create reports and dashboards using Power BI’s Analyze in Excel feature. Moreover, it may be more intuitive for Excel experts to learn Power BI gradually without abandoning Excel completely.
  • Data Exports: A colleague is interested in having the data behind the report, but they don’t have Power BI installed. Exporting the underlying data to Excel is an easy solution. 
  • Cross-tool use: If you are working in a team with various types of data practitioners. Certain team members may use other tools such as R or Python. Exporting Power BI data and reports to Excel will allow them to do just that. 

Exporting Data from a Power BI Dashboard

Exporting Data from a Power BI Dashboard

Power BI Dashboards allow you to place visualizations, reports, and tables, all in one place for an at-a-glance view. However, oftentimes, you may want to investigate the underlying data behind the visualizations in your dashboard or send it to a colleague. Here are the steps to export data from a Power BI Dashboard:

  • Go to your Power BI instance and log in with your account’s credentials. If you don’t have an account, you will need to create one. 
  • Go to the Power BI dashboard in question and choose the data visualization from which you are interested in exporting the data.
  • Click More options (…) from the upper right corner of the chosen data visualization.
  • Select the option Export to .csv.
  • You can then open up this .csv file in Excel. 

Exporting Data from a Power BI Report

Exporting Data from a Power BI Report

Power BI Reports are often confused with Dashboards since they both contain data visualizations and tables. Reports can have more than one page and permit viewers to find different ways to filter, highlight, and slice the data. Moreover, they are a great option for creating comprehensive summaries of your to share with the stakeholders. 

There are the following steps to export data from Power BI Reports:

  • Access the report from Power BI Desktop. If you don’t have Power BI Desktop installed, go here
  • Choose the data visualization from which you are interested in exporting the data.
  • Click the tile settings of the chosen data visualization 
  • Select the option “Export data”.

Copying Power BI Tables into Excel

Copying Power BI Tables into Excel

The steps to copy a Power BI Table to Excel are very simple and intuitive:

  • Go to Power BI Desktop.
  • Choose the Power BI table you want and go to the data view option on the left side panel.
  • Right-click on the chosen table; in this case, it’s called “Sales.”
  • Select the option “Copy Table.” 
  • Create a new sheet in Excel and paste the content of the table by clicking the Paste icon or Ctrl + V

Exporting from Power BI into Excel with the “Analyze in Excel” Feature

In Power BI Service, there is an additional feature to bring a Power BI dataset into Excel. This can be useful to process the data into Excel and then use the processed data in Excel to generate data visualizations. These are three different ways to utilize the “Analyze in Excel” function of Power BI.

1. Analyze in Excel feature from My Workspace

Analyze in Excel feature from My Workspace

My Workspace in Power BI is a view that contains a collection of datasets, reports, and dashboards you’ve created in the past. You can use the Analyze in Excel feature to export any of these datasets and reports into Excel. Here’s how:

  1. Go to, where the collection of all your works will appear on your Power BI account.
  2. Select Download from the menu. If you haven’t done this already, click Analyze in Excel updates. This operation is mandatory, otherwise, the Analyze in Excel feature won’t work. 
  3. Once you’re ready, choose the Power BI dataset you want to analyze in Excel.
  4. Select More options (…) next to the dataset and then click “Analyze in Excel”.
  5. When you open the new excel file, enable the editing and content. You shouldn’t have problems if you have installed the Analyze in Excel updates. But in case you still have issues, check this article for further guidance.

2. Analyze in Excel feature from the view of the dataset

Analyze in Excel feature from the view of the dataset

An alternative method is to click the name of the dataset in your workplace.  A new page will be opened where you can select “Analyze in Excel” in the menu bar above the page.

3. Analyze in Excel feature from the report

Analyze in Excel feature from the report

The third and last way is to open a Power BI report and select Export → Analyze in Excel in the menu bar.

More Power BI Resources

We hope you found this tutorial useful. This article discussed different ways to export Power BI data to Excel. This functionality can be very useful when you want to store and analyze the data outside Power BI. You can do a deeper dive into Power BI with DataCamp’s resources.

Power BI courses

Introduction to Power BI

3 hr
Master the Power BI basics and learn to use the data visualization software to build impactful reports.
See DetailsRight Arrow
Start Course
See MoreRight Arrow

Power BI vs Tableau: Which Should You Choose in 2023?

Power BI or Tableau? This comparison will help you decide which of these tools to use for your data science and analytics needs.
Shaun Edmond's photo

Shaun Edmond

7 min

a great interview

The Essential Power BI Interview Questions For Every Level

Explore the questions you can expect in a Power BI job interview, whether you're a beginner, intermediate, or advanced Power BI practitioner.
Joleen Bothma's photo

Joleen Bothma

16 min

Ginger Grant- Dataframed 118.png

How Power BI Empowers Collaboration

Ginger Grant talks about Power BI, and the common mistakes organizations make when implementing Power BI, advanced use cases, and much more.

Richie Cotton's photo

Richie Cotton

39 min

Excel Basics Cheat Sheet

Learn the basics of Excel with our quick and easy cheat sheet. Have the basics of formulas, operators, math functions and more at your fingertips.
Richie Cotton's photo

Richie Cotton

18 min

Data Manipulation in Excel Cheat Sheet

Discover how to manipulate data in Excel using this convenient cheat sheet!
Adel Nehme's photo

Adel Nehme

4 min

Working with Geospatial Data: A Guide to Analysis in Power BI

Discover what geospatial data analysis is, the different types of geospatial data, and how to analyze geospatial data using Power BI.
Joleen Bothma's photo

Joleen Bothma

10 min

See MoreSee More