How to Export Power BI Query to Excel

Moving your data from Power BI into Excel is a common task, often necessary for quick sanity checks, ad-hoc analysis, or sharing insights with colleagues who live in spreadsheets. While Power BI is a powerhouse for creating interactive reports and dashboards, sometimes you just need a flat file. This tutorial will walk you through several straightforward methods to export your Power BI queries to Excel, from simple clicks to more powerful techniques.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Why Export from Power BI to Excel?

Before diving into the "how," it’s helpful to understand the "why." Exporting isn’t a step backward, it’s about using the right tool for the job. Here are a few common scenarios where an Excel export is the perfect solution:

• Ad-Hoc Analysis: You need to perform a quick calculation, create a small pivot table, or investigate a single data point without building a whole new report visual in Power BI.
• Collaboration: You’re sharing data with someone who doesn't have a Power BI Pro license or isn't familiar with the platform. An Excel file is universal.
• Simple, Static Reporting: Sometimes you need to embed a simple data table into a PowerPoint presentation or a Word document. A static Excel table is perfect for this.
• Data Validation: You might want to export the underlying data from a visual to double-check the raw numbers and ensure your calculations are working as expected.

Whatever your reason, getting your data out is easy once you know the options.

Method 1: The Simple Visual Export

This is the most common and direct way to pull data into Excel. It works on a visual-by-visual basis and is perfect for when you just need the data behind a specific chart or table you've already created.

Step-by-Step Guide:

1. Navigate to the report either in Power BI Desktop or the Power BI Service.
2. Hover your mouse over the visual you want to export. You'll see several icons appear in the header.
3. Click on the ellipsis icon (…) to open the "More options" menu.
4. Select Export data from the dropdown list.

After clicking "Export data," you'll be presented with a dialog box giving you a few choices. Let's break down what they mean.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Understanding Your Export Options

Summarized data vs. Underlying data

This is the most important choice you'll make in this process.

• Summarized data: This option exports the data exactly as you see it in the visual. If you have a bar chart showing total sales by country, it will export a table with two columns: Country and Total Sales. It exports the aggregated result, not all the individual transactions behind it. When you choose this, you can typically select the file format:
• Underlying data: This option exports a wider set of data table columns for the summarized row values that are being used to create the visual. Taking the 'sales by country' example, this might export all the individual sales transactions to make up the summarized "total" value. You might see columns like Date, Product Sold, and Customer ID, even if they aren't visible in the chart itself. This option is extremely useful for a deeper data dive. Note that administrators can disable this feature.

*Note on row limits:* Power BI does have some limitations on export size to prevent performance issues. A standard summarized export to .xlsx is capped at 150,000 rows, and an export to .csv is capped at 30,000 rows. If you need more than that, you'll want to explore the more advanced methods below.

Method 2: Copying a Table Directly from the Power Query Editor

What if you want to export the result of an entire query before it even gets to a visual? If you've spent time in the Power Query Editor cleaning, merging, and transforming your data, you might want to export that final, clean table.

This method is a clever and quick way to grab a snapshot of your query results.

Step-by-Step Guide:

1. From Power BI Desktop, click on the Transform data button on the Home ribbon. This will open the Power Query Editor.
2. In the Queries pane on the left, select the query (which represents a table) that you want to export.
3. The data preview for that query will appear in the main window. In the top-left corner of this data preview, you'll see a small table icon right above the row numbers and to the left of the first column header.
4. Right-click this table icon and click Copy entire table from the context menu.
5. Open a new workbook in Excel.
6. Click on cell A1 and paste the data (you can use the keyboard shortcut Ctrl + V).

Your entire table will now be in Excel. However, there's a major caveat to be aware of.

Limitation: The Power Query Editor only displays a preview of your data — typically the first 1,000 rows. This "Copy entire table" method only copies what's visible in that preview. It’s perfect for smaller tables or for getting a quick sample with the correct structure, but it’s not suitable for exporting large datasets.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Method 3: "Analyze in Excel" for a Live Dynamic Connection

This feature is a game-changer if you love working in Excel but want the power of your Power BI data model. Instead of a static, one-time export, "Analyze in Excel" creates a live, refreshable connection from an Excel workbook directly to your Power BI dataset that has been published to the Power BI Service. It essentially turns Excel into a client for your Power BI dataset, letting you build PivotTables and PivotCharts that are always up-to-date.

This is arguably the most powerful way users can connect Excel to the fully detailed dataset that backs your Power BI project reports.

Step-by-Step Guide:

1. Log into the Power BI Service (app.powerbi.com).
2. Navigate to the workspace where your desired dataset or report is published.
3. Find the dataset (it has a different icon than the report). Click the ellipsis (...) next to the dataset's name, then select Analyze in Excel. An alternative is to open the published report that is built from that dataset and then click Export > Analyze in Excel button from the ribbon at the top of the report. This button is sometimes hidden within the ellipsis (...) menu.
4. A small .odc (Office Data Connection) file will download to your computer.
5. Open this downloaded file. Excel will launch and likely ask for a security confirmation to enable the data connection. Click Enable.
6. You'll now see a blank PivotTable in your worksheet. More importantly, the PivotTable Fields pane on the right side will be populated with all the tables, columns, and measures from your Power BI data model!

You can now drag and drop these fields to build any report or table you need, just as you would with any other PivotTable, with the confidence that your data is coming directly from your managed Power BI dataset.

Things to Keep in Mind:

• This feature requires a Power BI Pro or Premium Per User (PPU) license for each user accessing the analysis file. Otherwise, a permissions warning may pop up in your project files.
• Data can be refreshed but this is not an “auto-updating” dynamic report. For updated data within the connected report to be reflected, all connected Excel analysis documents must have their dataset refreshed within the Power BI Service first, THEN the user of the connected document has to Refresh Connections within the connected Excel document.
• This offers by far the most analysis capabilities with no row limits by turning your desktop Excel application into the reporting engine using your published Power BI model as its data source.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Method 4: The Advanced Option Using DAX Studio

For more technical users, or those who need to export datasets that exceed the standard limits, DAX Studio is the ultimate tool. DAX Studio is a free, third-party application made for running Data Analysis Expressions (DAX) queries against various data models, including Power BI.

This method gives you raw, unfiltered access to your tables and has virtually no row limitations.

Step-by-Step Guide:

1. First, download and install DAX Studio (it’s available for free at daxstudio.org).
2. Open the Power BI Desktop file (.pbix) that contains the data you wish to export. It must be open for DAX Studio to connect to it.
3. Launch DAX Studio. A "Connect" dialog box will appear. It should automatically detect your open Power BI file. Select it and click Connect.
4. In the main query window, you will need to write a simple DAX query to return a table. The easiest command is EVALUATE. To get the entire contents of a table named 'Sales', you would write:
5. Next, locate the Output options, usually found just below the Home ribbon. The default is "Grid," which shows the results in DAX Studio itself. Change this to File.
6. Once you've selected File as the output, choose whether you want the export to be a CSV file or a Tab Delimited file (.txt).
7. Click the Run button. DAX Studio will prompt you to name your file and choose where to save it. After you save it, it will execute the query and export the entire table to that file, regardless of size.

This technique is fantastic for data migrations, detailed auditing, or creating large datasets for use in other systems.

Final Thoughts

As we've seen, exporting a query from Power BI to Excel can be as simple as a few clicks or as powerful as running custom DAX code. The best method truly depends on what you are trying to accomplish — from exporting a simple visual with summarized data, copying a cleaned table from Power Query, connecting with a live "Analyze in Excel" connection, or performing a full data export with DAX Studio.

The need to move and manipulate data across different platforms often comes from the friction of traditional reporting workflows. We built Graphed to smooth out that entire process. Instead of exporting CSVs to analyze data or rebuilding charts for a slide deck, you can just connect your sources and create dashboards in seconds by describing what you want to see in simple, plain English. It keeps your data live, sharable, and accessible to your whole team, no matter their technical skill level.