How to Save Power BI Table in Excel

Moving your data from a Power BI table into Excel is a common task, whether you're creating an ad-hoc report, sharing insights with a colleague, or just prefer to work in a spreadsheet. This guide provides a detailed walkthrough of several methods, from a simple one-click export to establishing a live connection for dynamic analysis. We’ll show you exactly how to get your data where you need it.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Why Move Data from Power BI to Excel Anyway?

While Power BI is a fantastic tool for interactive reporting and data visualization, sometimes you just need the raw numbers in a good old-fashioned spreadsheet. Here are a few common reasons people export their data:

• Ad-Hoc Analysis: You might want to run quick, one-off calculations, create a custom pivot table, or use specific Excel functions that aren’t available in Power BI.
• Stakeholder Preferences: Many people, especially in finance or operations, are more comfortable working within Excel. Providing data in a familiar format can make collaboration smoother.
• Integrating with Existing Models: You may need to incorporate Power BI data into a larger, pre-existing Excel financial model, forecast, or business plan.
• Static Reporting: Some situations require a static snapshot of data for a specific point in time, like for a monthly archive or a presentation appendix. Exporting to Excel is perfect for creating these frozen-in-time reports.

Whatever your reason, knowing the right way to transfer your data can save you a lot of time and hassle. Let’s explore the best methods to do it.

Method 1: Exporting Directly from a Power BI Visual (The Quick and Easy Way)

This is the most straightforward method and the one you’ll probably use most often. It's built directly into the Power BI interface and only takes a few clicks. It’s perfect for getting data out of a specific chart, table, or matrix you see on a report.

Step-by-Step Instructions:

1. Open Your Report in Power BI Desktop or Service Navigate to the Power BI report containing the visual you want to export. This works whether you are in the Power BI Desktop application or viewing the report online in the Power BI Service.

2. Find and Hover Over your Visual Identify the table or chart. For this example, let’s assume you have a matrix showing sales revenue by product category and region.

3. Click the ‘More options’ (...) Icon When you hover your mouse over the visual, a few icons will appear in the top right corner. Click on the ellipsis (three dots) to open the context menu. The "More options" ellipsis is your gateway to exporting data from any visual.

4. Select 'Export data' From the dropdown menu, choose the “Export data” option. This will open a new dialog box where you can configure your export.

5. Choose Your Data Format and Scope Here you have a couple of important choices:

• Summarized data vs. Underlying data:
• File format:

Once you’ve made your selections, click the "Export" button. Your file will be downloaded, and you can open it right away in Excel.

Graphed

Still Building Reports Manually?

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

Watch the Demo

A Note on Limitations

While incredibly convenient, this method has limitations on the amount of data you can export:

• For .xlsx files, the limit is typically 150,000 rows.
• For .csv files, the limit is generally 30,000 rows when exporting from Power BI Desktop, but can be much higher when exporting from the Power BI service.

If you need to export a table larger than these limits allow, you’ll need to use one of the more advanced methods below.

Method 2: Connecting Excel Directly with ‘Analyze in Excel’

Instead of creating a static copy of your data, what if you could connect Excel directly to your Power BI dataset and build reports that you could refresh with a single click? That's exactly what "Analyze in Excel" does. This feature creates a live PivotTable connection, giving you the power and flexibility of Excel powered by the trusted, centralized data model in Power BI.

Step-by-Step Instructions:

1. Publish Your Report to an Online Workspace This feature works through the Power BI Service, not the Desktop app. Make sure your Power BI report and its underlying dataset have been published to a workspace you have access to. You will also need a Power BI Pro or Premium license.

2. Locate Your Dataset in the Power BI Service Go to app.powerbi.com and navigate to the workspace where your content is stored. Instead of looking for the report, find the Dataset for that report. It will often have the same name.

3. Use the 'Analyze in Excel' Option Click the "More options" (...) next to the dataset name, and from the menu, select "Analyze in Excel." A popup may appear confirming the creation of an Excel file. Find your Dataset in the Service to reveal the Analyze in Excel feature.

4. Download and Open the Connection File (.odc) This action will create an Office Data Connection (.odc) file. Find the downloaded file and open it. Excel will launch and may ask for a security confirmation to enable the data connection - click “Enable.”

5. Build Your Report with the PivotTable Fields You’ll now see a blank PivotTable in Excel. On the right, the "PivotTable Fields" pane lists all the tables, columns, and measures from your Power BI dataset. You can now drag and drop these fields to build your summary, just like any other PivotTable. You're working in Excel, but the data is streamed directly from your Power BI model.

Graphed

Still Building Reports Manually?

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

Watch the Demo

The Key Benefit: Refreshable Data

The biggest advantage of this method is that the data isn’t a static export. It's a live connection. When the data in your Power BI dataset is updated, you can simply go to the "Data" tab in Excel and click "Refresh All" to see the latest figures populate your report. This is ideal for weekly or monthly dashboards created in Excel that rely on an official Power BI data source.

Method 3: Full Table Export with DAX Studio

If you need to export a complete, multi-million-row table that exceeds the visual export limits and you don’t want a live PivotTable connection, DAX Studio is your best friend. DAX Studio is a free third-party tool that allows power users and developers to run queries against a Power BI data model.

Step-by-Step Instructions:

1. Download and Install DAX Studio First, you’ll need to get the tool from daxstudio.org. The installation is quick and straightforward.

2. Open Your Power BI Desktop File Start by opening the Power BI file (.pbix) that contains the model and table you want to export.

3. Launch and Connect DAX Studio Open DAX Studio. The connection dialog will automatically detect your open .pbix file. Select it and click "Connect."

4. Write a Simple DAX Query The main part of the interface is the query window. To export an entire table, you just need a one-line DAX query using the EVALUATE function. The table name needs to be enclosed in single quotes.

EVALUATE 'Sales Data'

If your table name has spaces, like 'Sales Data', you must use quotes. If it doesn’t, like 'Sales', the quotes are optional. When you start typing, DAX Studio's IntelliSense will help you find the correct table name.

A simple EVALUATE query is all it takes to select an entire table in DAX Studio.

5. Set the Output Destination and Run Before running the query, look at the "Output" options just above the query window. The default is "Grid," which shows the results in the interface. To save directly to Excel, change this to "File." Then, click the dropdown next to the "Run" button and select "Run and Export (Excel)." DAX Studio will prompt you to choose a location to save your file. Once saved, it will execute the query and stream all the raw data directly into the specified Excel file, bypassing the normal Power BI export limits.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Method 4: Quick Copy & Paste from Data View

Sometimes you don't need a formal export, you just want to grab the full table for a quick check or some light manipulation. For this, a simple copy-and-paste from Power BI Desktop's Data View gets the job done.

Step-by-Step Instructions:

1. Switch to Data View: In Power BI Desktop, click on the grid icon on the left-hand navigation bar to open the Data View.
2. Select Your Table: In the "Fields" pane on the far right, find and click on the table you want to copy. The data will display in the main window.
3. Copy the Table: Right-click on the table name in the Fields' pane (not on the data itself) and select "Copy table" from the context menu.
4. Paste in Excel: Open a blank Excel workbook and press Ctrl+V (or right-click and 'Paste'). The entire table will be pasted into the spreadsheet.

This is a surprisingly fast and efficient method for small to moderately sized tables. However, for extremely large tables with millions of rows, it may cause Power BI or Excel to become unresponsive, so use it with caution on very large datasets.

Final Thoughts

There are several effective ways to save a Power BI table in Excel, each suited for a different purpose. Exporting from a visual is great for quick summaries and sharing, Analyze in Excel is best for creating refreshable reports, and DAX Studio offers an escape hatch for exporting massive tables without limits. The best approach simply depends on your end goal.

While moving data between apps is often necessary for those one-off tasks, it can also be a sign that it’s difficult to get quick answers from your data. At Graphed, we help you overcome this by connecting your marketing and sales sources into one place, allowing you to build real-time dashboards and reports using simple natural language. Instead of exporting data to answer a new question, you can just ask it directly and get an instant visualization, helping you move from data to decisions much faster.