How to Export to XLSX in Power BI

Exporting data from Power BI into an Excel XLSX file is one of the most common tasks for analysts and report consumers alike. While Power BI is fantastic for interactive visualization, sometimes you need a static snapshot for a presentation, need to perform custom calculations in a familiar environment, or need to share insights with someone who doesn't have access to Power BI. This guide will walk you through the various ways to get your data out of Power BI and into a structured Excel file, ready for your next steps.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Why Export Power BI Data to Excel?

Before jumping into the "how," it's helpful to understand the "why." People export data from Power BI to Excel for several practical reasons. Knowing your goal will help you choose the best export method for your needs.

• Further Analysis: Excel is armed with powerful features like PivotTables, complex formulas, What-If Analysis, and the Solver add-in. Exporting data allows you to leverage these tools for deep-dive analysis that might be more cumbersome or not possible within Power BI's interface.
• Sharing with Stakeholders: Not everyone in your organization has a Power BI license or the time to explore an interactive dashboard. Exporting key visuals or underlying data into an easily digestible Excel file makes it simple to share insights with colleagues, clients, or management.
• Static Reporting & Archiving: Business reporting often requires creating static, point-in-time snapshots for monthly or quarterly reviews. An XLSX file serves as a perfect, unchangeable record of performance for a specific period. It's a reliable way to archive data for historical reference.
• Data Integration with Other Processes: Sometimes, the data from your Power BI report is just one piece of a larger workflow. You might need to export it to combine it with data from another system in Excel or to upload it into a different application that only accepts file imports.

Whatever your reason, Power BI provides several dependable methods to bridge the gap between your dashboard and your spreadsheet.

Method 1: Exporting Data Directly from a Visual

The most direct method is exporting data straight from a single visual - be it a table, matrix, line chart, or bar graph - within your Power BI report. This approach is ideal when you need the data powering a specific part of your dashboard.

Follow these simple steps:

1. Open Your Report: Navigate to the report in the Power BI service (app.powerbi.com) or in Power BI Desktop.
2. Select a Visual: Hover your mouse over the visual you want to export data from. You will see a few icons appear in the header of the visual.
3. Find More Options: Click on the ellipsis (...) icon to open the "More options" menu.
4. Choose "Export data": In the dropdown menu, click on "Export data." This will open an options window.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Understanding Your Export Options

Once you click "Export data," you'll be presented with a dialog box asking how you want to export the data. This is a critical step, as the choice you make determines what data you’ll get.

Summarized data

This is the default option and typically the one you’ll use most often. It exports the data exactly as you see it aggregated in the visual.

• What it does: It takes the dimensions, measures, and active filters applied to the visual and exports that summarized view. For instance, if you have a bar chart showing 'Total Sales by Country,' exporting summarized data will give you a table with two columns: 'Country' and 'Total Sales' - one row for each country displayed.
• Best for: Quickly getting the high-level numbers from a chart or table to use in a presentation or summary report.
• File Format: You can choose *.xlsx* (Excel) which has a limit of 150,000 rows, or a *.csv* file with a limit of 30,000 rows. For our purpose, select .xlsx.

Underlying data

This option lets you see the detailed, row-level data that makes up the visual. It essentially gives you access to the source table rows that contribute to the aggregation in your visual, while still respecting the filters applied.

• What it does: Instead of just getting the final 'Total Sales by Country', you would get the individual transaction data that Power BI aggregated to create those totals. This might include columns like ‘Order ID’, ‘Product Name’, ‘Date’, and ‘Sale Amount’ for every sale in the filtered countries.
• Best for: When you need to audit the specific transactions behind a number or perform your own detailed analysis on the raw data. Be aware that Power BI might perform some behind-the-scenes data model expansion, so it may not look exactly like your raw source file.
• File Format: This option supports exporting as an `.xlsx* (Excel) file with a limit of 30,000 rows or connecting to the data via a table in the data model for Power BI premium users (a more advanced topic).

After choosing your data type and file format (.xlsx), click the "Export" button. Your browser will download the Excel file, which you can then open and start working with immediately.

Method 2: Using the "Analyze in Excel" Feature

For more experienced users who want to perform ongoing, dynamic analysis in Excel, the "Analyze in Excel" feature is a game-changer. Instead of creating a one-time static export, this method connects your Excel workbook directly to your Power BI dataset in the cloud.

This creates a live, refreshable connection, meaning your Excel report will always be up-to-date with the latest data in your Power BI model. It’s like having a Power BI-powered PivotTable right inside Excel.

Prerequisites for "Analyze in Excel"

• Permissions: You need to have "Build" permissions for the Power BI dataset you want to connect to.
• Power BI Admin Settings: A Power BI administrator must have this feature enabled for your organization.
• Excel Version: You must be using a modern version of Microsoft Excel (included with Microsoft 365 is best).
• Provider Installation: The first time you use this, you may be prompted to install required drivers that let Excel communicate with Power BI.

Graphed

Still Building Reports Manually?

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

Watch the Demo

How to Use "Analyze in Excel"

1. Navigate to the Power BI service and open the workspace containing the dataset or report you want to analyze.
2. Find the dataset you want to connect to. Click the ellipsis (...) next to it and select "Analyze in Excel." Alternatively, if you're viewing a report, you may find it under the "Export" menu in the top navigation bar.
3. A .odc (Office Data Connection) file will be created and downloaded by your browser.
4. Open this .odc file on your computer. Excel will launch and may ask you to enable data connections. Click "Enable."
5. Once connected, you'll see a blank PivotTable on the left and a "PivotTable Fields" pane on the right. This pane lists all the tables, columns, and measures from your Power BI dataset.
6. Start building! Drag and drop fields into the Rows, Columns, Values, and Filters areas just like you would with any other PivotTable to create your custom report.

The beauty of this method is its dynamic nature. You can save this Excel file, and the next time you open it, just right-click your PivotTable and hit "Refresh" to pull the latest data directly from the Power BI service. No more manual weekly downloads.

Method 3: A Quick 'Copy Table to Clipboard'

Sometimes you don't need a full-blown export. You just want a quick grab of the numbers in a table visual to paste into an email, a Teams chat, or a temporary spreadsheet. For this, the "Copy" functionality is perfect.

1. In Power BI, select the table or matrix visual you want to copy.
2. Click the ellipsis (...) icon for "More options."
3. From the menu, choose "Copy table to clipboard."
4. Open Excel, click on a cell, and press Ctrl + V (or right-click and "Paste").

This method pastes the data as a table in Excel, preserving basic formatting. It’s much faster than exporting a file but is only suitable for small, simple tables you see on screen.

Best Practices and Common Limitations

While exporting data is straightforward, keeping a few things in mind will help you avoid common pitfalls.

Be Mindful of Row Limits

Power BI imposes limits on how much data you can export from a visual at once to maintain performance:

• Summarized Data to XLSX: 150,000 rows
• Underlying Data to XLSX: 30,000 rows
• Data to CSV: 30,000 rows

If your data exceeds these limits, the export will be truncated. For very large datasets, you should consider using "Analyze in Excel," connecting to the dataset directly with tools like DAX Studio, or applying more filters in Power BI to reduce the export size.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Check Data Types and Formatting

Power BI and Excel handle some data types and formats differently. While most number and text formats translate well, be prepared to do some minor re-formatting in Excel, especially with dates or custom number formats.

Think About Data Security

Remember, once you export data from Power BI, it becomes a static and unsecured file. It is no longer governed by Power BI's Row-Level Security or other access controls. Be cautious about where you store a downloaded file and who you share it with, especially if it contains sensitive information.

Final Thoughts

Getting your data from a dynamic Power BI report into a static Excel spreadsheet is a necessary part of many analytics workflows. Whether you're quickly exporting the summarized data from a single chart, creating a dynamic connection for in-depth PivotTable analysis, or just copying a small table, Power BI gives you flexible options to match your needs.

This process of exporting data and wrangling it in spreadsheets highlights a common cycle: analysts spend more time gathering and preparing data than actually finding insights. At Graphed, we help you break that cycle. Connecting your data sources directly to our platform lets you build live, real-time dashboards and get answers using simple, natural language - no need for constant XLSX exports or manual report updates. Your data is always current, and insights are a simple question away.