How to Extract Data in Power BI

Getting your data out of a Power BI report can be just as important as getting it in. While dashboards are great for high-level monitoring, sometimes you need the raw numbers for a different report, some quick ad-hoc analysis in Excel, or to share with a colleague who doesn’t use Power BI. This guide will walk you through several methods for extracting data, from simple one-click exports to more advanced techniques for handling 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

Why Extract Data from Power BI?

Before jumping into the "how," it helps to understand the "why." You're not exporting data just to create more files on your computer. Common scenarios where extracting data is necessary include:

• Offline Analysis: You need to dig into the numbers on a plane or somewhere without internet access.
• Sharing with Others: You need to send a specific slice of data to a stakeholder, client, or auditor who doesn't have a Power BI Pro license.
• Using Data in Other Applications: You might want to use the processed data from Power BI in a PowerPoint presentation, a Word document, or another analytical tool.
• Creating Static Backups: For compliance or archival purposes, having a static copy of the data at a specific point in time can be a requirement.

Understanding your goal will help you choose the right extraction method from the ones outlined below.

Method 1: Exporting Data Directly from Visualizations

This is the most straightforward and common way to get data out of Power BI. If you see a chart or table and want the numbers behind it, this is your go-to method.

When to Use This Method

This approach is perfect for grabbing small, specific datasets quickly. It’s ideal when your question is "What numbers are making up this exact chart?" and you need a quick CSV file to work with.

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

Step-by-Step Instructions

Let's say you have a bar chart showing total sales by country. Here’s how to export the data that powers it:

1. Hover your cursor over the visualization in your report.
2. Three dots (ellipses) will appear in the top-right corner of the visual. Click them to open a context menu.
3. Select Export data from the dropdown menu.

At this point, you'll see a dialog box that gives you a critical choice:

Summarized Data vs. Underlying Data

This is the most important decision you'll make here, and understanding the difference is essential.

• Summarized Data: This gives you a table of exactly what you see in the visual. For our "Sales by Country" chart, you would get a two-column file: one column for "Country" and one for the summed "Total Sales." It's an aggregated view.
• Underlying Data: This gives you all the individual rows from your dataset that were used to create the visual's summary. Instead of one row for "United States," you'd get every single transaction record for sales that occurred in the United States. This will be a much larger file and is perfect when you need the granular details for further analysis.

Limitations to Keep in Mind

While convenient, this method has a few limitations you should be aware of:

• Row Limits: Exports have hard caps. You can typically export a maximum of 30,000 rows to a .csv file and 150,000 rows to an .xlsx file for underlying data. Exporting summarized data is capped at 150,000 rows for both. If your underlying data is larger, Power BI will only export the first chunk, which can be misleading if you’re unaware.
• Admin Controls: Your Power BI administrator can disable data exporting for the entire organization for security or governance reasons. If you don't see the "Export data" option, this is likely why.
• Visual-Specific Data: This method only exports data that is relevant to the one visual you selected. It doesn’t export data from the entire report page or the entire dataset.

Method 2: Use the 'Analyze in Excel' Feature

Sometimes you don't want a dead, static CSV file. You want to maintain a live connection to your Power BI data but use the familiar comfort of Excel's PivotTables to slice and dice it. This is exactly what "Analyze in Excel" was designed for.

When to Use This Method

This is the best option for users who are comfortable in Excel and want to perform flexible analysis without creating outdated data extracts. Think of it as creating a live-linked PivotTable, directly connected to your Power BI model. It’s great for finance teams who need to build custom reports in Excel off an official, governed Power BI dataset.

Step-by-Step Instructions

This feature is available in the Power BI Service (app.powerbi.com), not in Power BI Desktop.

1. Navigate to the Power BI Service and open the report or dataset you want to analyze.
2. In the menu bar above the report, click on Export and then select Analyze in Excel.
3. This will download a small file with an .odc (Office Data Connection) extension.
4. Open this file. Excel will launch and may ask for your permission to enable data connections — say yes.
5. You'll be presented with a blank PivotTable in Excel. On the right-hand side, in the "PivotTable Fields" pane, you will see all the tables and measures from your Power BI dataset, ready for you to drag and drop to build your analysis.

The beauty of this method is that the data stays current. If the dataset in Power BI gets refreshed, you can simply right-click your PivotTable in Excel and hit "Refresh" to pull in the latest numbers.

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: Advanced Extraction with DAX Studio

What happens when you hit the 30,000-row export limit but need the entire dataset? For experienced users and analysts who need to extract millions of rows or entire tables from a data model, the built-in export options won't cut it. This is where external tools like DAX Studio come to the rescue.

What is DAX Studio?

DAX Studio is a free third-party tool that allows you to connect to Power BI (and other data models) and run DAX (Data Analysis Expressions) queries directly against it. Don’t let the term "queries" intimidate you, it can be as simple as just telling it to dump an entire table into a single file.

When to Use This Method

Use DAX Studio when you need to bypass Power BI's built-in export limits entirely. It’s perfect for:

• Extracting an entire data table that has millions of rows.
• Running a complex calculation with DAX and exporting the resulting custom table.
• Archiving a full copy of a table for auditing purposes.

Basic Steps to Extract a Full Table

1. First, you'll need to download and install DAX Studio (it's completely free).
2. With your .PBIX report open in Power BI Desktop, launch DAX Studio.
3. The tool will automatically detect your open Power BI file. Simply select it and click "Connect."
4. On the right side of the main window, you'll see a query pane. To extract a full table, you just need a one-line DAX query. For a table named 'Sales', you would type:
5. Next, find the "Output" options in the Home ribbon at the top. Change the output target from Results to "File."
6. Choose "CSV File" as the format and select where you want to save the large file.
7. Finally, click the "Run" button. DAX Studio will execute the query and stream all the data directly to the CSV file you specified, completely bypassing any of Power BI's export limitations.

While it requires an extra tool, DAX Studio gives you uncompromised access to the data in your model whenever you need it.

Method 4: Copying from Power Query

The Power Query Editor is the "back-end" powerhouse of Power BI where you clean and transform data before it ever hits your report visuals. While not a primary export tool, it has a handy trick up its sleeve for nabbing tables of data.

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

When to Use This 'Copy Paste' Method

This is an underrated technique for quickly grabbing the full contents of a smaller table that has already been cleaned in Power Query. It’s great when you want a preview of your transformed data to paste directly into an Excel worksheet, for instance.

Step-by-Step Instructions

1. In Power BI Desktop, go to the Home tab and click Transform data to open the Power Query Editor.
2. From the Queries pane on the left, select the table you wish to extract. You'll see an interactive preview of the table.
3. Click the small table icon in the top-left corner of the data preview. This action selects the entire table.
4. Right-click on the selected table and choose Copy entire table from the context menu.
5. You can now switch over to Excel or Google Sheets and simply paste the data.

This isn't practical for massive tables, but for smaller tables or dimension tables with a few hundred or a few thousand rows, it’s often faster than any other method.

Final Thoughts

Learning how to get data out of Power BI is a critical skill that turns your reports from static views into a flexible source of truth. Whether you're quickly exporting from a visual for a slide deck, using "Analyze in Excel" for live data exploration, or leveraging DAX Studio for a heavy-duty data dump, choosing the right method depends entirely on what you're trying to accomplish.

We know that even with a powerful tool like Power BI, the process of connecting to data, building reports, and performing analysis can have a steep learning curve. At Graphed, we’re making data analysis as easy as having a conversation. You can connect all of your marketing and sales data sources like Google Analytics, Shopify, Facebook Ads, or HubSpot in just a few clicks. Instead of spending hours learning DAX or setting up visuals, you simply ask questions in plain English, and we build live, real-time dashboards for you in seconds. It allows anyone on your team to become their own data analyst and get immediate answers.