Can We Export Power BI Report to Excel?

Chances are, someone on your team has asked you to "just put it in Excel." Despite its powerful visualization features, getting your data out of a Power BI report and into a familiar spreadsheet is a common, and often necessary, task. This article will walk you through exactly how to export your Power BI data to Excel, covering the different methods available and when to use each one.

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 in the First Place?

While Power BI is a best-in-class tool for interactive dashboards, sometimes you need the specific functionality of Excel. The reasons can vary, but most users export data for one of the following reasons:

• Familiarity and Comfort: Many people have spent years working in Excel. It's a familiar environment where they feel comfortable performing quick calculations, sorting, and filtering without needing to know the ins and outs of Power BI.
• Ad-Hoc Analysis: You might want to run a quick, one-off analysis, build a simple financial model, or manually manipulate a subset of data in a way that's faster in a spreadsheet than building a new visual.
• Sharing with Non-Power BI Users: Not everyone in your organization or among your clients will have a Power BI license. Exporting to Excel is the universal way to share data with colleagues who can't access the original report.
• Offline Access: If you need to review data on a plane or in a location without a stable internet connection, an exported Excel file is your best bet.
• Legacy Workflows: Sometimes, data from a Power BI report needs to be fed into an existing, Excel-based process or a legacy system that doesn't integrate directly with modern BI tools.

Two Quick Things to Check Before You Export

Before jumping into the "how-to," there are two critical things to understand that can save you a lot of confusion: permissions and limits. If you can’t export, it’s almost always for one of these two reasons.

1. Do You Have the Right Permissions?

Not everyone can export data from every report. To export data, you generally need Build permission for the underlying dataset that the report is based on. If you see the "Export data" option is grayed out, it's a strong sign you don't have the necessary access.

Additionally, a Power BI administrator for your organization can disable data exporting for the entire company or for specific user groups. So if you believe you have build permissions but still can't export, you may need to check with your IT team or Power BI admin.

Graphed

Still Building Reports Manually?

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

Watch the Demo

2. Be Aware of Export Limits

Power BI has guardrails to prevent users from exporting massive datasets, which can strain performance. Keep these limits in mind:

• For .xlsx file exports (from both Power BI Service and Desktop), there's a limit of 150,000 rows.
• For .csv files, the limit from the Power BI Service is an odd 30,000 rows. But you can export up to 500,000 rows to .csv if you're pulling underlying data from a visual built with a DirectQuery connection.
• Live connection reports to Analysis Services have a limit of around 150,000 rows as well.

If you need to export more data than these limits allow, you'll need to use the "Analyze in Excel" feature (more on that below) or connect directly to the data source from within Excel itself.

Method 1: Exporting Data from a Visual in Power BI Service

This is the most common and straightforward method. You find a specific chart or table in a published report and pull the data from it directly.

Step-by-Step Instructions:

1. Navigate to the report in your Power BI workspace (app.powerbi.com).
2. Hover your mouse over the visual (a bar chart, pie chart, table, etc.) that contains the data you want to export.
3. In the top-right corner of the visual, click the "More options" (...) ellipsis icon.
4. From the dropdown menu, select "Export data."

After you click "Export data," a dialog box will appear with a few key options. It’s important to understand the difference between them.

Summarized Data vs. Underlying Data

Summarized Data

This option exports the data exactly as you see it displayed in the visual. If your bar chart shows total sales revenue for each month, exporting summarized data will give you an Excel file with two columns: "Month" and "Sum of Sales Revenue," with one row for each month. It gives you the high-level summary.

When you choose this, you can typically export as:

• .xlsx (Excel) with live connection (Preview): Creates an Excel workbook with a live connection to your Power BI dataset — perfect for PivotTables. Works best for tabular visuals where layout is an important part of your final format.
• .xlsx (Excel): A standard formatted Excel file.
• .csv: A comma-separated values file — useful for unformatted, raw data.

Underlying Data

This option exports the detailed, row-level data that is being aggregated or summarized in your visual. Using the same example of a sales chart, exporting underlying data would give you the raw transaction table behind that chart. You would get rows for every single sale that was made, including columns like Sale ID, Customer Name, Product Sold, Timestamp, and Sale Amount. This is much more granular and useful for deep-dive analysis. You will see columns from the underlying dataset that aren't even used in the source report visual, which you can use for your own further evaluation.

Typically, in Power BI Service (the browser version of Power BI), you only have a single export option for the file type: .xlsx.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Finalizing the Export

Once you’ve made your choice, click the blue "Export" button. Your browser will download the file, which you can then open directly in Excel. This creates a static, one-time copy of the data. If the data in the Power BI report updates, your Excel file will not automatically refresh.

Method 2: Exporting from Power BI Desktop

The process in Power BI Desktop is nearly identical to the online service, but with a slight difference in the file output.

1. Open your report (.pbix file) in the Power BI Desktop application.
2. Click on the visual you want to export from.
3. Click the "More options" (...) icon in the corner of the visual.
4. Select "Export data."

Here, rather than picking a file type from a dialog box, Power BI Desktop will immediately open a "Save As" window, prompting you to save the file as a .csv file on your computer. It exports the underlying data for that visual. There are no options for file types, it defaults to CSV.

Method 3: "Analyze in Excel" for a Live, Refreshable Connection

If you need your exported data set to be more than just a snapshot, the powerful "Analyze in Excel" feature is your tool of choice. Instead of creating a static export, it creates a live connection between Excel and your Power BI dataset, turning Excel into a front-end client for your data model. Essentially, it allows you to build a PivotTable in Excel that is directly connected to your Power BI data.

How to Use Analyze in Excel

1. In the Power BI Service, open the report or the workspace containing the dataset you want to analyze.
2. In the menu bar at the top of the report, click on "Export" and then select "Analyze in Excel."
3. A file with a .odc (Office Data Connection) extension will be downloaded.
4. Open this .odc file from your downloads folder. Your device might prompt you with a security warning before it connects to an external connection, a process it has likely already set up a one-time connection to through the Office 365 license manager.

Excel will open with a blank PivotTable. On the right-hand side, in the "PivotTable Fields" pane, you'll see all the measures and columns from your Power BI dataset, ready for you to use. You can now drag and drop these fields to build your own custom reports and pivot tables, just as you would with any other data source.

Graphed

Still Building Reports Manually?

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

Watch the Demo

The Benefits of Analyze in Excel

The biggest advantage is that the data is refreshable. Simply go to the "Data" tab in Excel’s ribbon and click "Refresh All" to pull the latest information from your Power BI dataset. This method marries the robust, governed data model in Power BI with the beloved flexibility of Excel PivotTables, giving you the best of both worlds.

Method 4: Quick and Dirty Copy and Paste

Sometimes, all you need is a small slice of data from a table or matrix visual. In these cases, a full export can be overkill. There’s a much faster way.

1. In your Power BI report, hover over a table or matrix visual.
2. Click on the "..." ellipsis in the top corner of the visual.
3. Select Copy value from choices listed, such as “visual as image,” “export to data,” or “pin to dashboard.”

This is extremely useful when copying single data points, and only takes a single click into any cell in any table in any program.

Tips and Best Practices

• Remember Your Filters Affect the Outcome: All export methods respect the filters currently applied to your report. If you’ve filtered the report to only show data for Q1, your export will only contain Q1 data. Make sure your slicers and filters are set correctly before you export.
• Choose the Right Method for the Job: Use a simple visual export for a static summary. Use “Analyze in Excel” when you need refreshable data for ongoing analysis in a PivotTable.
• Be Mindful of Data Security: Once data is exported into an Excel file, it lives outside of Power BI's controlled environment. Any row-level security or data protection policies you have in Power BI no longer apply to that file. Be careful about where you store and who you share these exported files with.

Final Thoughts

Yes, you can absolutely export Power BI reports to Excel, and there are several different ways to do it. Whether you need a quick .csv dump, a formatted report, or a live, refreshable connection for PivotTable analysis, Power BI provides a tool that fits the task at hand. The best method simply depends on what you plan to do with the data once it's in your spreadsheet.

For many marketing, sales, and e-commerce teams, the constant cycle of logging into different analytics tools, exporting CSVs, and wrangling them in spreadsheets is a huge time sink. We built Graphed to solve this problem by eliminating the manual work altogether. Instead of pulling static reports from systems like Power BI or Google Analytics, we allow you to connect all your data sources and use natural language to build and chat with live, real-time dashboards that always stay up-to-date, freeing up hours each week for analysis instead of data prep.