How to Export Data from Power BI Dashboard

Exporting data from a Power BI dashboard is an essential skill for turning brilliant visualizations into actionable data for other applications. Whether you need to run a quick analysis in Excel, share findings with a colleague, or import figures into a presentation, this guide will walk you through the different ways to get your data out of Power BI and into your hands.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Why Export Data from a Power BI Dashboard?

While Power BI is a phenomenal tool for interactive data exploration, there are many practical reasons why you might need a static copy of your data. The core purpose of exporting is to move information from the Power BI environment into another format for a different task.

Common scenarios include:

• Deeper Analysis in Excel: Excel remains the go-to tool for many analysts. Exporting to a .csv or .xlsx file allows you to create custom pivot tables, run unique calculations, or apply specific formatting that isn’t available in Power BI.
• Sharing with Stakeholders: Not everyone in your organization has a Power BI license or the time to navigate complex reports. Exporting a summary table to share in an email or a Teams chat can be a fast and effective way to disseminate information.
• Integrating into Reports and Presentations: You might need to include a specific chart's data in a PowerPoint slide, a Word document, or a Google Slides presentation. An export gives you a clean data set to work with.
• Creating Backups or Snapshots: Sometimes you need to capture a snapshot of data at a specific point in time for audit purposes, historical record-keeping, or to compare against future performance.

Before You Get Started: Understanding Permissions and Limits

Before you try to export, it’s important to understand that not all users can export all data. Power BI has a permission-based system designed to protect sensitive information. If you're running into issues, it's likely related to one of the following constraints.

Permissions

To export data, you typically need "Build" permission for the underlying dataset. This permission is granted by the report's owner or an administrator. If you only have "Read" access (meaning you can view the dashboard but not edit or build on it), your export options will be limited or disabled entirely. If you feel you need to export and can't, the first step is always to contact the person who shared the report with you.

Administrator Settings

A Power BI administrator for your entire organization can also disable data exporting for certain user groups or for the entire company. This is a common security measure to prevent data leakage. If a colleague with the same role can export but you can't, it's a permissions issue with the report. If no one can, it may be a company-wide policy.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Data Row Limits

Power BI isn't designed for massive data exports, its goal is to visualize summarized information. Because of this, Microsoft imposes limits on the number of rows you can export:

• .csv file: Max 30,000 rows.
• .xlsx (Excel) file (summarized data): Max 150,000 rows.
• .xlsx file (underlying data): Max 1,000,000 rows (in Power BI Desktop and Power BI Service).

If your data exceeds these limits, the exported file will be truncated. The best practice to avoid this is to apply filters directly within the Power BI report before exporting to reduce the dataset to a more manageable size.

How to Export Data from a Dashboard Visual

Power BI dashboards are the top-level-view canvases, often showing single visualizations (tiles) from multiple different reports. Exporting from a dashboard tile itself is simple but offers limited options - it's typically just a .csv file of the summarized data.

Here’s how to do it:

1. Navigate to the dashboard containing the visual you're interested in.
2. Hover your mouse over the tile (the specific chart or number visualization) you want to export data from.
3. In the top-right corner of the tile, click the More options (...) ellipsis.
4. From the dropdown menu, select Export to .csv.

The file will be automatically generated and downloaded by your browser. This .csv file contains only the data used to create that specific visualization - nothing more. It’s a quick and easy way to grab the high-level numbers you see on the screen.

How to Export Data from a Report Visual (Detailed Guide)

More often than not, clicking a dashboard tile will take you to its underlying report. Reports are where the detailed, interactive exploration happens, and they offer far more powerful and flexible export options.

If you're already viewing a report, or if you've clicked through from a dashboard, follow these steps:

1. Identify the specific visual (e.g., a bar chart, line chart, or table) from which you want to export data.
2. Hover your mouse over the visual to make its options appear.
3. Click the More options (...) ellipsis in the top-right corner of the visual's container.
4. A context menu will appear. Select Export data.
5. This opens a new dialog box where you can choose exactly what data you want and in what format.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Understanding Your Export Options

This dialog box is where you make the key decisions. Let's break down what each choice means.

1. Summarized Data

This is the most common option. "Summarized data" means you'll export the data exactly as you see it displayed in the visual. If the chart is showing total sales by month, your export will contain two columns: "Month" and "Total Sales." It exports the aggregated results, not the thousands of individual sales that make up those totals.

For this option, you can choose a file format:

• Excel (.xlsx) with live connection: Keep the data link so it can be refreshed later. It maintains filters and is best for dynamic analysis.
• Excel (.xlsx): Exports to a standard Excel file with rows limit of up to 150,000. It retains the number formatting from the Power BI visual.
• CSV (.csv): Exports a comma-separated values file - a universal plain-text format - with a 30,000-row limit. This is great for compatibility with other programs but loses any special number formatting.

2. Underlying Data

This is the most powerful option, but also the one that requires "Build" permissions. "Underlying data" exports the detailed, row-level data that is being summarized in your visual. For a chart showing total sales by month, exporting the underlying data might give you a large table with columns for every single transaction: Transaction ID, Date, Product, Customer ID, and Sale Amount.

This is extremely useful when you want to perform a full, detailed analysis in Excel or another BI tool. Your only file choice here is usually an .xlsx file, and as noted, this can handle a much larger number of rows.

When to Choose Summarized vs. Underlying Data

• Choose Summarized Data when: You need an exact copy of the numbers shown in a chart for a presentation or email and want the numbers to perfectly match what's visible on the report.
• Choose Underlying Data when: The chart pointed you to an interesting trend, and now you need to dig into the individual records to find out why that trend is happening.

Using “Analyze in Excel” for Live Connections

For users who live inside spreadsheets but want to leverage the clean, governed data inside a Power BI dataset, the "Analyze in Excel" feature is a game-changer. Instead of a one-time static export, this method creates a direct, refreshable link between an Excel file and your Power BI data.

Here’s how to set it up:

1. From within a Power BI report in Power BI Service, select Export > Analyze in Excel in the navigation bar. You might see the option in a dropdown menu in a workspace page instead.
2. This downloads a small Office Data Connection (.odc) file.
3. Find the downloaded file and open it. Excel will launch and may ask you for permission to enable editing and/or content. Approve it.
4. That's it! In Excel, you will see an empty PivotTable on the left and a PivotTable Field List on the right containing fields from the underlying Power BI dataset model.

You can now build a PivotTable inside Excel by dragging and dropping measures and dimensions just as you would with any other data. The key benefit is the Refresh button in Excel's Data tab. When the data in Power BI is updated, you can click "Refresh" to get the latest numbers without having to re-export anything.

Common Issues and Troubleshooting Tips

Sometimes things don't go as planned. Here are fixes for the most common issues users encounter when exporting from Power BI.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Issue: The “Export data” option is grayed out or missing.

Cause: This is almost always a permissions issue. It means you don't have the necessary "Build" permissions for the dataset the report is built on top of. It may also have been turned off by a report administrator for that specific visual.

Solution: Contact the owner of the report or your Power BI administrator and request "Build" permissions for the associated dataset.

Issue: My exported file is incomplete.

Cause: You’ve hit the row limits. A data export that exceeds 30,000 rows for .csv or 150,000 for .xlsx will simply be cut off.

Solution: Return to the Power BI report and apply more filters. For example, instead of exporting all sales data for the year, filter the report to show one month or one specific product category at a time and export the data in smaller chunks.

Issue: I don't have the option to choose “Underlying data.”

Cause: This option only appears for users with "Build" permissions. If you only have viewer access, you'll only be able to export the summarized data.

Solution: As with the grayed-out button, the solution is to request elevated permissions from the report owner or administrator.

Final Thoughts

Pulling data out of Power BI is a common and necessary task, whether you're creating deep-dive analyses in Excel or just grabbing numbers for an email. Knowing the difference between exporting from a dashboard versus a report, understanding your limits, and choosing between summarized and underlying data will help you get the exact information you need, quickly and efficiently.

Of course, the need to constantly export data to different tools often highlights the friction in traditional BI workflows. Manually downloading CSVs and wrestling with spreadsheets is time-consuming and prone to errors. At Graphed, we automate the painful parts by connecting directly to your primary data sources. Instead of exporting, filtering, and pivoting manually, you can simply ask questions in plain English - like "create a chart comparing campaign spend to Shopify revenue last quarter" - and get a live, interactive dashboard built in seconds, keeping all your analysis in one place, always up-to-date.