How to Export Power BI Report to Excel

Getting your Power BI report into Excel is a common need, whether for offline analysis, sharing with colleagues, or just drilling down into the raw numbers in a familiar environment. While Power BI is a fantastic tool for visualization and interactive dashboards, sometimes a spreadsheet is simply the right tool for the job. This guide will walk you through the various ways to export your data from Power BI to Excel, covering everything from simple chart summaries to the full underlying dataset.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why Export from Power BI to Excel?

Before jumping into the "how," it’s helpful to understand the "why." While the goal is always to keep your data live and interactive within Power BI, there are several practical reasons you might need an export:

• Ad-Hoc Analysis: You might want to run some what-if scenarios, build a quick financial model, or just "play" with the numbers without affecting the official report.
• Sharing with a Wider Audience: Not everyone in your organization has a Power BI license or is comfortable navigating its interface. Excel is universal, making it easy to share specific slices of data.
• Specific Formatting Needs: Sometimes you need a highly customized, print-ready table or report. While Power BI’s Paginated Reports handle this, a quick export to Excel often suffices for simpler needs.
• Data Integration: The exported Excel file can serve as an input for another business process, presentation, or a software tool that doesn't connect directly to Power BI.

The Primary Method: Exporting Data from a Visual

The most straightforward way to get data out of Power BI is by exporting it directly from a specific visual like a chart, table, or matrix. Power BI gives you two main options here: summarized data and underlying data.

1. Exporting Summarized Data

Summarized data is exactly what it sounds like - it’s the aggregated data that you see in the visual. If you have a bar chart showing sales by country, exporting the summarized data will give you an Excel file with a list of countries and their corresponding total sales.

How to Export Summarized Data:

1. Navigate to your report in either Power BI Desktop or the Power BI Service.
2. Hover your cursor over the visual you want to export. An ellipsis icon (three dots) will appear in the top-right corner.
3. Click the ellipsis icon to open the More options menu.
4. Select Export data.
5. A dialog box will appear. Here, make sure Summarized data is selected.
6. Under File format, choose your desired format. For a standard spreadsheet, select .xlsx (Excel).
7. Click the Export button. Power BI will generate the file and your browser will begin the download.

This method is quick, easy, and perfect for when you just need a snapshot of the chart’s data. However, be aware of a key limitation: exports of summarized data to .xlsx are limited to 150,000 rows. For larger datasets, you’d need an alternative approach.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

2. Exporting Underlying Data

What if you need more than just the summary? Exporting the underlying data gives you all the columns and rows from your data model that are being used to create that visual — before they are aggregated.

For example, if your bar chart shows total sales per country, the summarized data gives you one row per country. The underlying data, on the other hand, gives you every single sales transaction that comprises those totals, along with related model data on the same row. This is incredibly powerful for detailed analysis.

How to Export Underlying Data:

1. Follow the same initial steps: hover over the visual, click the ellipsis, and click Export data.
2. In the dialog box, select Underlying data instead.
3. Choose your file format. You'll have two options: Excel (.xlsx) or CSV (.csv).
4. Click Export to download the file.

A few important things to note about this method:

• Permissions: Report designers and administrators can restrict access to this option. If you don't see the "Underlying data" choice, it’s likely that your permissions for this report don't allow it.
• Row Limits: Just like summarized data, exporting underlying data to .xlsx has a row limit of 150,000. Exporting to .csv can handle much larger datasets — typically millions of rows — determined by the Admin settings configured for your Power BI tenant.
• Data Model Dependencies: This export may include data from multiple tables in your model if your visual is using fields from them. Power BI intelligently flattens this out into a single table in your export file.

Advanced Techniques for Exporting to Excel

Beyond exporting from a single visual, Power BI offers more integrated ways to connect your data to Excel.

Use "Analyze in Excel" for a Live Connection

This is arguably the most powerful way to bring your Power BI data into Excel. Instead of creating a static, one-time export, "Analyze in Excel" creates a live connection from an Excel workbook directly to your Power BI dataset.

With this method, you can build PivotTables, PivotCharts, and regular tables in Excel, but the data source is your curated, governed Power BI dataset. Best of all, the data can be refreshed with a single click in Excel.

How to Use Analyze in Excel:

1. Go to the workspace in Power BI Service that a report or dataset is in.
2. Find your dataset (it has an orange icon) in the list and click the ellipsis (...) next to it.
3. From the menu, select Analyze in Excel. This initiates the download of an .odc (Office Data Connection) file.
4. Open the downloaded file. Excel will ask for your permission to enable data connection — click Enable.
5. You might be prompted to sign in with your Power BI credentials.
6. Once connected, an empty PivotTable will appear, and you’ll see all your Power BI dataset tables and measures in the "PivotTable Fields" pane, ready to be analyzed.

Heads up: To use this feature, users need a Power BI Pro or Premium Per User (PPU) license and sufficient "Build" permissions on the dataset.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Copy and Paste From a Table Visual

For a quick, low-tech solution for small datasets, you can often just copy the data straight from a table or matrix visual.

How to Copy a Table Visual:

1. On your Power BI report, click the ellipsis (...) on your table or matrix visual.
2. Select Copy table from the context menu after you have selected specific values from a table.
3. Navigate to where you want your content in Excel or another program to be, and simply press CMD + V to paste.

This method is incredibly fast but does have limitations. It works well for small amounts of data without specific export configurations or considerations from other types of actions. Often it can just be the best option when you need to make changes to the file to reupload it back to another platform quickly. This doesn't maintain any formatting or data types consistently, but it is super fast in almost every other use case. If you have only a couple of hundred records, for example, and you just want to do a quality check, this would be the quickest way.

Best Practices and Common Issues

Exporting seems simple, but there are a few things to keep in mind to avoid common frustrations.

Know the Export Limits

Row limits are the most common source of confusion. Memorize these:

• Summarized Data (.xlsx): 150,000 rows
• Underlying Data (.xlsx): 150,000 rows
• Underlying Data (.csv): No limit set in Power BI Desktop. The limit in Power BI service is configurable by admins, but can go up to hundreds of MB worth of CSV
• Analyze in Excel: The Power BI queries that Excel sends back will be more like a DirectQuery and are able to be substantially larger, given that large datasets often require more computation on refreshes and are more likely to time out and return errors.

If you need to export more data than a certain limit allows for in a single export, a good step to work around it is by using filters in your canvas to make smaller chunks to join together later with another tool or directly with Excel using its Merge function. It is important to know which is better (merging within another program to use in reports with Power BI, for example, or joining queries to use as a bigger offline dataset using a spreadsheet program).

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Check Administrator Settings

If you can't see the export options, they might be turned off by your organization's Power BI administrator. In the Power BI Admin Portal, there are explicit settings to allow or disallow tenants to Export to Excel and have a Download reports option, in addition to other specific data governance tools. Some companies may not use these because their licenses are per-user with no budget to expand. If issues arise, consulting with your IT manager can assist in troubleshooting export problems.

Think About Data Security

Remember, once data is in an Excel file, it's out of Power BI’s protective ecosystem. All Row-Level Security (RLS) is gone. The file is static and can be emailed or shared anywhere, potentially exposing sensitive information. Before exporting, always ask yourself: "What data is in this file, and who should have access to it?"

Final Thoughts

Moving data from Power BI to Excel opens up new avenues for analysis and sharing, giving you crucial flexibility. By using the methods outlined above, you can confidently choose the right export option — from a simple chart summary to a dynamically connected PivotTable — for whatever task you have. Knowing the limits and security implications will help you work smarter and safer.

We know that manually exporting reports one by one can become a repetitive chore, eating up time better spent on action and strategy. This is why we created Graphed. Our platform automates much of this busywork by connecting directly to your sources, allowing you to build live, cross-channel dashboards with simple natural language. Instead of exporting CSVs or wrestling with API connectors, you can just ask for the report you need and get immediate, real-time insights.