How to Save Power BI Report as Excel

Moving data from a Power BI report into Excel is a common and straightforward task, whether you need to run a quick ad-hoc analysis or share information with a teammate who lives in spreadsheets. This guide covers several different methods, from exporting a single chart's data to creating a live connection to your entire dataset.

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?

While Power BI is a fantastic tool for creating interactive dashboards and visualizing data stories, there are still plenty of valid reasons to send your data over to Excel. Business intelligence isn't about picking one tool and sticking with it, it's about using the right tool for the right job. You're not abandoning Power BI - you're just using Excel for a specific task it excels at.

Common reasons to export include:

• Familiarity and Flexibility: Sometimes you just need to "play" with the numbers in a familiar environment. Excel's cell-based structure is ideal for quick calculations, creating custom tables, or using specific formulas that aren't readily available in Power BI.
• Sharing with Others: Not everyone on your team or in your organization will have a Power BI license or know how to navigate a report. Exporting key data to an Excel file is a simple way to share insights with stakeholders who operate primarily in spreadsheets.
• Static Reporting: Power BI is dynamic and interactive by design. If you need to create a static, point-in-time report - like a snapshot for a monthly presentation or a PDF attachment for an email - exporting the summarized data to Excel provides a stable view of the numbers.
• Advanced Ad-Hoc Analysis: Power BI focuses on aggregated views and structured models. For certain deep-dive analyses, such as building a complex financial model or using Excel features like Goal Seek or Solver, having the raw data in a spreadsheet is essential.

Method 1: Exporting Data Directly from a Visual

This is the most common and direct way to get data out of Power BI. It allows you to grab the numbers powering a specific chart, table, or card and save them as an Excel or CSV file. This method is perfect when your focus is on a single component of your report.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step-by-Step Instructions

1. Open Your Report: Navigate to the report in either Power BI Desktop or the Power BI service (the cloud version).
2. Select the Visual: Hover your mouse over the visual (e.g., a bar chart, line graph, or matrix) that contains the data you want to export.
3. Find "More options" (...): An ellipsis icon (three dots) will appear in the top-right corner of the visual's container. Click it to open a dropdown menu.
4. Click "Export data": This will open the export dialog box, giving you two primary choices for how to get your data.

Understanding Your Export Options

Once you click "Export data," you'll need to choose the format. The dialogue you see may vary slightly depending on your permissions and the type of data, but you'll generally have two paths:

1. Summarized Data

Choose this option when you want the data exactly as it's displayed in the visual. If your chart shows sales by month, exporting summarized data will give you an Excel file with two columns: "Month" and "Sum of Sales."

• File Type: Exports as an .xlsx (Excel workbook) file.
• What's Included: Only the dimensions and measures currently used in the visual.
• Use Case: Perfect for recreating a specific chart in Excel, providing a clean summary to a colleague, or getting a quick, aggregated view.
• Row Limit: You can export a maximum of 150,000 rows.

2. Underlying Data

Choose this option when you need more detail than what is shown in the visual. For example, your chart might show total sales by country, but exporting the underlying data could give you every single transaction that makes up that total, including customer ID, product sold, and an exact timestamp.

• File Type: You can choose between .xlsx (with a 150,000-row limit) or .csv (with a much higher row limit - we'll get to that).
• What's Included: All the data from the underlying data table that is used to create the visual, not just the aggregated view. This gives you a more raw, granular dataset.
• Use Case: Best for deep-dive analysis, troubleshooting data issues, or when you need access to the individual records.
• Important Note: To use this option, you need to have "Build" permissions on the dataset. If you don't, this option may be grayed out.

After selecting your preference and file type, simply click the "Export" button. Your file will download, ready to be opened in Excel.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Method 2: Creating a Live Connection with "Analyze in Excel"

While exporting from a visual is great for static data pulls, the "Analyze in Excel" feature is the go-to for more robust, interactive reporting. Instead of just exporting a single slice of data, this powerful feature connects your entire Power BI dataset to Excel, creating a pivot table that you can build and modify on the fly.

Think of it as bringing Power BI's "Fields" pane directly into Excel. This is an excellent option for business analysts and data-savvy users who are comfortable with pivot tables but want to leverage the clean, governed data models built in Power BI.

Step-by-Step Instructions

1. Go to the Power BI Service: This method is available in the online Power BI service, not Power BI Desktop. Log in to your Power BI account.
2. Locate Your Dataset: Go to the workspace that contains the report or dataset you want to analyze. You can find your dataset in the list of contents within a workspace or via the "Data hub."
3. Click "More options" (...): Find the dataset you want to work with and click the ellipsis next to its name.
4. Select "Analyze in Excel": This will initiate the download of an .odc file (Office Data Connection). You might need to install these updates if prompted.
5. Open the File in Excel: Locate the downloaded .odc file and open it. Excel will likely show a security warning, click "Enable" to proceed.
6. Start Building: Once enabled, Excel will open with a blank PivotTable. The PivotTable Fields pane on the right-hand side is now populated with all the tables, measures, and columns from your Power BI dataset - just like in Power BI Desktop! You can now drag and drop fields to build reports, create charts, and slice the data however you see fit.

Benefits and Considerations

• Dynamic Connection: Your Excel PivotTable is connected directly to the Power BI dataset. You can refresh the data anytime from the "Data" tab in Excel to pull the latest information from the service.
• Full Data Model Access: You're no longer limited to the data in one visual. You have secure access to the entire model to answer new and follow-up questions.
• Requirements: You must have a Power BI Pro or Premium Per User (PPU) license. Your Power BI admin must also have enabled this feature for your organization.

Method 3: Copy and Paste a Table

For a very small, quick task, sometimes the simplest solution is the best. If all you need is the data from a table visual and it’s not very large, you can often just copy and paste it.

This is the quick-and-dirty method. It’s not elegant, but it works in a pinch.

1. In your Power BI report, find or create a table visual with the columns and rows you need.
2. Click the ellipsis icon (...) in the corner of the table visual.
3. Go to "More options" and select "Copy table."
4. Open a new Excel sheet and simply paste (Ctrl + V).

Be aware that this approach works best for smaller tables. The formatting may not translate perfectly, and it's a static copy of the data, but it can be the fastest way to get numbers into a spreadsheet for a quick calculation.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Key Things to Remember for a Smooth Export

If you're running into issues or the options aren't appearing as expected, check these common points:

• Permissions Are Paramount: Your ability to export, especially viewing underlying data or using Analyze in Excel, depends on the permissions assigned to you by the report creator or workspace admin. If options are grayed out, you may need to request "Build" permissions for the dataset.
• Admin Settings Rule: A central Power BI administrator for your company can disable data exporting on a tenant-wide level or for specific security groups. If you believe you should have export access but don't see the options at all, check with your IT or data analytics team.
• Understand the Row Limits: Keep the export limits in mind. If you need more than 150,000 rows, exporting the underlying data to a CSV file is your best option from a visual. If you require even more data, a more advanced solution like connecting to the data source via a dataflow might be necessary.
• Pick the Right Tool: Once again, choose your method based on your goal:

Final Thoughts

Getting your data out of Power BI and into Excel is a flexible process tailored to different needs. Knowing which export option to use in which situation allows you to leverage the strengths of both platforms - Power BI for governed, interactive reporting and Excel for detailed, ad-hoc tasks. By understanding permissions, limits, and the difference between summarized and underlying data, you can make this a seamless part of your workflow.

This process of manually exporting from one platform to another is often part of a frustrating weekly reporting cycle - downloading CSVs on Monday to build reports for a Tuesday meeting, which then leads to follow-up questions. We built Graphed to break this cycle entirely. Instead of shuffling data between platforms, you can connect your raw data sources and simply ask questions in plain English to instantly build live dashboards and reports, turning hours of data-wrangling into a 30-second task.