How to Copy Data from Power BI

Need to pull some data out of a Power BI report and into a spreadsheet for some quick analysis or to share with a colleague? It happens all the time. This guide walks you through the best ways to copy and export your data, from simple one-click options for a single chart to more powerful methods for grabbing the entire underlying dataset.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Why Copy Data from Power BI in the First Place?

Power BI is a fantastic tool for interactive data visualization, but sometimes you need your data in a different format. Here are a few common reasons you might need to export it:

• Deeper analysis in Excel: Use familiar spreadsheet functions, PivotTables, or statistical tools that aren’t available in Power BI.
• Sharing static data: Send a simple table of numbers to someone who doesn't have a Power BI license or access to your report.
• Combining with other sources: Perform a one-off task involving Power BI data and other system information in a simple spreadsheet.
• Creating ad-hoc reports: Quickly format data in a specific way for a document or presentation faster in Excel or Google Sheets.

Whatever your reason, Power BI provides several ways to get this done.

Method 1: The Standard Way - Exporting Data from a Visual

This is the most common and straightforward method. It allows you to grab the numbers directly from any chart, graph, or table in your report.

Step-by-Step Instructions

1. Open your Power BI report and navigate to the page with the visual you want to copy.
2. Hover over the visual to reveal the header icons. Click on the “More options” ellipsis (...) icon. This usually appears in the top-right corner.
3. In the dropdown menu, select "Export data."
4. A dialog box will appear, giving you a few important choices. This is the most crucial step.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Understanding Your Export Options: Summarized vs. Underlying Data

You’ll be asked how you want to format the data export. This choice determines what information you actually get.

Summarized data

This option exports the data exactly as you see it in the visual. If you’re looking at a bar chart showing total sales by month, you’ll get a table with two columns: "Month" and "Total Sales." It exports the aggregated values, not the thousands of individual sales that make up those totals.

• Use this when: You need a high-level summary that matches the chart you're looking at.
• File format: You can choose either an Excel file (.xlsx) or a CSV file (.csv).

Underlying data

This option gives you the raw, detailed data that feeds the visual. For that same sales chart, "Underlying data" would give you all the individual transaction rows used to calculate the monthly totals. This can be thousands or even millions of rows of data.

• Use this when: You need to perform your own detailed analysis, create new summaries, or audit the numbers in your spreadsheet.
• File format: It will export as an Excel file (.xlsx).

After you make your choice, a file will be downloaded, and you can open it in your spreadsheet program of choice. Be aware that Power BI has export limits (often 150,000 rows for .xlsx summarized exports or 30,000 for .csv), and your organization's administrators may have disabled data exporting altogether.

Method 2: Super Fast Copy & Paste for Tables and Matrices

If you're working with a table or matrix visual and just need to quickly copy the data into an email or a spreadsheet without creating a new file, this is the method for you.

How to Copy a Table

1. Select the table or matrix visual in your report. You don't need to hover.
2. Go to the “More options” (...) menu in the corner of the visual.
3. Hover over "Copy" and select "Copy table." (For older reports, you might see "Copy selection").
4. The entire table of data is now copied to your clipboard. Simply navigate to Excel, Google Sheets, or even a Word document and press Ctrl+V (or Cmd+V on Mac) to paste it.

This method is incredibly fast for small datasets. It often keeps basic formatting like headers, but it’s best when speed is more important than perfect structure.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Method 3: Analyze in Excel (The 'Live Connection' Method)

Instead of a static copy, what if you could connect Excel directly to your Power BI data model and build PivotTables that stay up-to-date? That's exactly what the "Analyze in Excel" feature does. This is the most robust and flexible option for serious spreadsheet users.

It essentially treats your published Power BI dataset as the source for an Excel PivotTable.

Step-by-Step Instructions

1. Open Microsoft Excel. Go to the Data tab on the Ribbon.
2. Click Get Data > From Power Platform > From Power BI.
3. A new window will open on the right, listing all the Power BI datasets you have access to. Find and select the dataset that powers the report you're interested in.
4. Excel will then create a live connection to that dataset and start a blank PivotTable.
5. In the PivotTable Fields pane, you can now see every table, column, and measure from the original Power BI model. You can drag and drop fields to build the exact table or report you need, right inside Excel.

The beauty of this method is that the data is live. You can hit the "Refresh" button in Excel's Data tab, and it will pull the latest data from the Power BI service. Once you've created your table in the Pivot, you can copy it as static values and paste them anywhere.

Method 4: The Advanced Technique Using Performance Analyzer

For more technical users, there's a clever way to get the exact data query behind a visual. The Performance Analyzer is a tool meant to help developers optimize slow reports, but we can also use it to extract the DAX query that Power BI uses to generate a visual.

Graphed

Still Building Reports Manually?

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

Watch the Demo

How to Copy a DAX Query

1. In your Power BI report, go to the View tab and click on Performance Analyzer. This opens a new pane on the side.
2. Click "Start recording" and then click "Refresh visuals."
3. The pane will populate with a list of every element on your report and how long it took to load. Find the visual you’re interested in and expand the entry.
4. You'll see a section called "DAX query." Click the "Copy query" button.

You now have the exact code on your clipboard. You can paste this query into a separate tool like DAX Studio or Tabular Editor which connects directly to your Power BI data model. Running the query there will give you the complete, unfiltered data table, effectively bypassing any export limits imposed by the Power BI interface.

This is an advanced move, but it’s the most powerful way to guarantee you get the exact data you want, without any limitations.

Final Thoughts

From a quick copy-paste to a live connection in Excel, Power BI gives you plenty of options for exporting your data. For most everyday tasks, exporting directly from a visual works perfectly. For more in-depth spreadsheet analysis, the "Analyze in Excel" feature is by far the best choice, giving you a refreshable and interactive way to explore your entire dataset.

Much of this exporting is done because data lives in separate systems, and our BI tools only show one piece of the puzzle. This feeling - of having to manually connect the dots every week by pulling CSVs - is why we built Graphed. We connect all your marketing and sales sources automatically, then let you create dashboards and get answers in plain English. Instead of exporting from one system to piece together insights in another, we provide a unified view, so you can just ask what you want to know and get an instant, real-time answer without the manual data wrangling.