How to Copy Power BI Visual to Excel

Ever built the perfect visual in Power BI only to realize you need to get that same data into Excel? It's a common scenario, whether you're building a simpler report for a stakeholder, doing some ad-hoc analysis, or just prefer to work in a spreadsheet. This guide will walk you through the various ways to copy and export your Power BI visual data directly into Excel.

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

Understanding Your Export Options in Power BI

Power BI provides several ways to move data from a visual into another application like Excel. The best method depends on what exactly you need to do with the data. Do you want the summarized data exactly as it appears in the chart? Or do you need the full, unsummarized dataset that feeds the visual? Understanding this distinction is the first step.

Here’s a quick breakdown of your main choices:

• Copying the Visual as an Image: This copies a static picture of your chart or table. It's useful for presentations or documents where you don't need the underlying numbers, just the visual representation.
• Exporting Summarized Data: This gets you the data exactly as it’s shown in the visual. If your chart shows total sales by month, you’ll get a table with two columns: ‘Month’ and ‘Total Sales.’ This is the most common and direct method for copying what you see.
• Exporting Underlying Data: This gives you the full dataset behind the visual, including all the rows and columns "underneath" the summarized view. If your monthly sales chart is built on thousands of individual transaction records, exporting the underlying data will give you all those transactions, not just the monthly totals.

We’ll cover the step-by-step process for each of these scenarios below.

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 1: Copy a Visual as an Image or Table with Formatting

Sometimes, all you need is a quick snapshot of your visual to paste into an Excel file, a PowerPoint presentation, or an email. This is the fastest way to share the look of your data without worrying about the raw numbers.

Step-by-Step Instructions:

1. Navigate to your Power BI report and hover over the visual you want to copy.
2. Click the "More options" ellipsis (...) that appears in the top-right corner of the visual's header.
3. From the dropdown menu, find and hover over the "Copy" option. You'll see two choices:
4. Select your desired option. A dialog box will appear confirming that the visual or table has been copied.
5. Open your Excel workbook, select the cell where you want to paste the visual, and use the paste command (Ctrl + V on Windows or Cmd + V on Mac).

If you copied as an image, you'll get a picture. If you copied as a table, Excel will paste the data along with the formatting from Power BI, like colors and bold headers. This is great for maintaining a consistent look and feel across your reports.

Method 2: Export Summarized Data from a Visual

This is the most popular method for getting the exact numbers from a Power BI visual into Excel for further analysis. You get a clean CSV file containing only the data points represented in your chart or table.

Step-by-Step Instructions:

1. In your Power BI report, hover over the visual you want to export.
2. Click the "More options" ellipsis (...) in the top-right corner.
3. Select "Export data" from the dropdown menu.
4. A new window will pop up. Under the "Which data would you like to export?" section, ensure the "Summarized data" option is selected. This is usually the default.
5. For the "File format" dropdown, you can choose:
6. Click the "Export" button. Power BI will generate the file, which will then download to your computer.
7. Open the downloaded CSV file in Excel. You'll see a clean table of the data that matches what you saw in the Power BI visual.

When to Use Summarized Data

This method is perfect when the visual itself tells the full story you need. For example:

• You've created a bar chart showing website sessions by marketing channel for the last month. Exporting summarized data gives you a simple two-column table: Channel and Sessions.
• Your pie chart shows sales distribution by region. The summarized export provides a table of regions and their corresponding sales totals.

Don't use this if you need to perform calculations on the raw transaction data that makes up those summaries. For that, you’ll want to export the underlying data.

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: Export Underlying Data from a Visual

Sometimes the summary isn’t enough. You need the granular, row-level data feeding the visual to do a deeper dive. The "Export underlying data" feature gives you access to the full dataset that is being used to build the chart, subject to certain administrative limitations.

Step-by-Step Instructions:

1. Just like before, hover over the visual and click the "More options" ellipsis (...).
2. Click "Export data."
3. In the pop-up window, select the "Underlying data" option. You may also see a checkbox allowing Power BI to apply filters or not - keep it checked if you want the export to respect the slicers and filters active on your report page.
4. Select your desired file format. You'll typically have two options here:

For large datasets, CSV is often faster and more efficient as it doesn't have the row limitations of older Excel versions (though modern Excel can handle millions of rows). Generally, .XLSX is a good choice for smaller to medium datasets.

1. Click "Export." Your browser will download the file containing the raw, unsummarized data.

Considerations & Limitations

• Admin Permissions: Your organization’s Power BI administrator can disable the ability to export underlying data for certain reports or for all users. If you don't see the "Underlying data" option, it’s likely restricted.
• Data Limits: There are limits on how much data can be exported at once. For exports to .xlsx, the limit is 150,000 rows. For .csv, the limit is higher, often around 30,000 rows when using Power BI Desktop, but can be much larger on the Power BI service. If you need more data, you might have to apply filters to export chunks of the data separately or use other tools like Power BI’s own "Analyze in Excel" feature for very large datasets.
• Calculations and Measures: The underlying export will include the raw columns used in the visual, but it won't necessarily replicate complex DAX measures in a column. The values will be calculated, but the formula itself won't be exported.

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

Bonus Tip: Using the Performance Analyzer

Here's a clever, lesser-known trick to grab the DAX query that Power BI uses to generate a visual. Once you have the query, you can run it yourself using other tools (like DAX Studio) to get the data.

This is an advanced technique, but it’s incredibly powerful if you're comfortable with DAX.

1. Go to the "View" tab in the Power BI Desktop ribbon.
2. Click on "Performance Analyzer." A new pane will open on the right.
3. Click "Start recording."
4. Then, click "Refresh visuals."
5. The Performance Analyzer will log every query for every visual on the page. Find your specific visual in the list.
6. Expand its details and you'll see a line for "DAX query." Click the "Copy query" link.

You can now paste this DAX query into a tool like DAX Studio, which connects to your Power BI model, run it, and export the results to Excel. It gives you the ultimate control over the data retrieval process.

Final Thoughts

Moving data from a Power BI visual to Excel is a straightforward process once you know the options available to you. For a quick visual copy, use the "Copy visual as image" feature. For most analytical needs, exporting the "summarized" or "underlying" data to a CSV or XLSX file is the best approach. It all comes down to what you're trying to accomplish in Excel.

If you're often finding yourself jumping between platforms just to analyze data, you might appreciate how we've built Graphed to simplify this whole process. We connect directly to your data sources and allow you to build dashboards or get answers just by asking in plain English. This can save you the hassle of exporting CSVs and manually wrangling data, allowing you to get from question to insight in seconds, not hours.