How to Convert Power BI File to Excel

Have a beautiful Power BI report in front of you but need to get that data into Excel? You’re not alone. While Power BI is incredible for interactive dashboards, sometimes you need the familiar flexibility of a spreadsheet for ad-hoc analysis, sharing with a colleague, or a specific calculation. This guide will walk you through four practical methods to convert your Power BI data into Excel, from quick exports to dynamic, live connections.

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 Anyway?

Moving data from a powerful visualization tool back into a spreadsheet might seem like a step backward, but there are plenty of valid reasons why it’s a necessary part of a team’s workflow. Excel remains the go-to tool for certain tasks, and knowing how to bridge the gap between it and Power BI is a valuable skill.

Common scenarios include:

• Sharing with non-Power BI users: Not everyone on your team or in your client's organization may have a Power BI license or the know-how to navigate a report. A simple Excel file is universally accessible.
• Ad-Hoc Calculations: You might need to run a quick, one-off analysis, build a small financial model, or test a hypothesis with formulas that are easier to write in Excel than DAX (Data Analysis Expressions).
• Creating Static Snapshots: Sometimes you need to archive a point-in-time record of your data, such as month-end performance numbers, without it constantly updating.
• Using Specific Excel Features: You may have existing Excel templates, macros, or specific charting styles you need to use with the data from your Power BI report.

Whatever your reason, the goal is the same: to get the data you see in Power BI into a workable Excel format. Let’s look at how to do it.

Method 1: Export Data Directly from a Visual

This is the most straightforward and common method for grabbing data from a specific chart, graph, or table inside your Power BI report. It’s perfect for when you just want the numbers behind one piece of your dashboard.

When to Use This Method:

Use this option when you need a quick static export of the data driving a single visual. It’s ideal for grabbing summarized numbers for a slide deck or sending a simple table to a coworker.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step-by-Step Instructions:

1. Navigate to the report you want to export from in either Power BI Desktop or the Power BI service online.
2. Hover your cursor over the visual (e.g., a bar chart, line graph, or pie chart) that contains the data you need.
3. Click on the ellipsis icon (...) that appears in the top-right corner of the visual. This opens the "More options" menu.
4. From the dropdown menu, select "Export data."

After clicking "Export data," you’ll be presented with a dialog box giving you a few choices. This is where you need to make an important decision.

Choosing Your Data Format: Summarized vs. Underlying

You will typically see two options for exporting your data:

• Summarized data: This option exports the data exactly as you see it in the visual. If you have a bar chart showing total sales by country, you’ll get an Excel file with a column for "Country" and a column for "Total Sales" — one row for each country displayed. It's pre-aggregated and perfectly matches the chart. You'll have the choice between an .xlsx (Excel) or a .csv file.
• Underlying data: This option gives you the raw, individual rows of data that were used to create the visual's summary. Using the same sales-by-country example, this export would give you every single sales transaction that was summed up to create the chart. This provides much more detail for deeper analysis but can result in a very large file. Not all visuals will have this option, and administrators can disable it. Note that exporting underlying data usually has a row limit (often 30,000 for .csv and 150,000 for .xlsx), so it may not be suitable for massive datasets.

Once you’ve made your choice, Power BI will generate and download the file for you. Just open it up, and you’re ready to go in Excel.

Method 2: Use "Analyze in Excel" for Dynamic Reports

If you're an avid PivotTable user, this method will feel like magic. Instead of a static data dump, "Analyze in Excel" creates a live connection from an Excel workbook directly to your Power BI dataset. This allows you to build PivotTables and PivotCharts in Excel that are powered by your master dataset in Power BI.

When to Use This Method:

This is the best option when you want to explore a full dataset using Excel’s familiar PivotTable interface. Because the connection is live, you can refresh your data with a single click to get the latest numbers without having to export anything again.

Step-by-Step Instructions:

1. Log into the Power BI service (app.powerbi.com) in your web browser.
2. Navigate to the workspace that contains the report or dataset you want to work with.
3. Find the dataset you wish to analyze. Make sure you select the dataset, not the report (datasets have an icon that looks like an orange cylinder). Click the ellipsis (...) next to the dataset's name.
4. Select “Analyze in Excel” from the menu. This will prompt a download of an .odc (Office Data Connection) file.
5. Find the downloaded .odc file on your computer and open it. Excel will likely show a security warning, click "Enable" to allow the connection.

Excel will then open a blank workbook with the PivotTable Fields pane already active on the right-hand side. You will see all the tables and measures from your Power BI dataset, ready for you to drag and drop into the Rows, Columns, Values, and Filters areas, just like a standard PivotTable. Any report you build will be pulling real-time data from Power BI every time you hit refresh.

Graphed

Still Building Reports Manually?

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

Watch the Demo

A Quick Note on Prerequisites:

To use "Analyze in Excel," you generally need a Power BI Pro or Premium license. You may also be prompted to install an updated library called the "Analysis Services OLE DB provider" if your version of Excel needs it to communicate with Power BI.

Method 3: Connect to a Power BI Dataset from Excel's "Get Data" Tool

Similar to "Analyze in Excel," this method creates a live connection, but it's initiated from within Excel itself using the built-in Power Query engine. This approach gives you more granular control over exactly which tables and columns you want to pull into your Excel workbook.

When to Use This Method:

Choose this method when you want to pull specific tables or columns from a Power BI dataset into Excel, rather than connecting the whole dataset to a PivotTable. It's also great if you want to combine the Power BI data with other data sources using Power Query inside Excel.

Step-by-Step Instructions:

1. Open a new or existing workbook in Excel.
2. Go to the “Data” tab on the Ribbon.
3. Click “Get Data” -> “From Power Platform” -> “From Power BI.” (Depending on your Excel version, it might be located under "From Azure" or "From Online Services".)
4. A pane will appear on the right side of your screen. If you're not already, you'll be prompted to sign in to your Microsoft account associated with Power BI.
5. After signing in, you’ll see a list of all the Power BI datasets you have access to across your workspaces.
6. Click on the dataset you want to connect to. Excel will then ask how you want to load the data. You can either load the tables directly into your workbook or click "Transform Data" to open the Power Query editor for more advanced shaping.
7. Once loaded, your data will appear in a regular Excel table, and you can refresh it at any time by going to the “Data” tab and clicking “Refresh All.”

Method 4: Copy a Table Visual to Your Clipboard

Sometimes you don't need a formal export file or a live data connection. You just need a small, simple table to paste somewhere - fast. For those moments, there's a handy copy-paste feature.

Graphed

Still Building Reports Manually?

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

Watch the Demo

When to Use This Method:

This is the down-and-dirty method for quick, informal data transfers. It's perfect if you just need to drop a table into an email, a Teams message, or a new spreadsheet without messing with file downloads.

Step-by-Step Instructions:

1. In your Power BI report, make sure the data you want is in a Table visual. If it's in a chart, you can easily change the visual type to a table just for this purpose.
2. Hover over the table visual and click the ellipsis (...) in the top-right corner.
3. Go to "More options" -> "Copy table." (For older versions or specific visuals, this may look slightly different).
4. Open your Excel workbook and simply paste the data (Ctrl + V or Cmd + V).

The table will appear in your spreadsheet with basic formatting. It’s a static copy, so it won’t update, but for a quick snapshot, it's often the fastest way to get the job done.

Final Thoughts

Moving your data from Power BI to Excel isn't a sign of failure - it's a sign of a flexible and pragmatic workflow. Whether you're doing a quick export from a single chart, creating a dynamic PivotTable with "Analyze in Excel," or pulling data directly with Power Query, you have multiple ways to get the format you need. Choosing the right method depends entirely on whether your goal is a quick snapshot or a refreshable, ongoing report.

While an Excel export is handy for ad-hoc analysis, a lot of that wrangling comes from trying to answer follow-up questions that weren't in the original report. That's exactly why we built Graphed. Instead of building a complex report and then exporting it to drill down, we let you connect your key data sources - like Google Analytics, Shopify, HubSpot, or Salesforce - and just use natural language to find answers instantly. Want to see conversion rates by campaign? Or your sales pipeline for this quarter? Just ask, and Graphed builds a live dashboard for you in seconds, saving you from the export-to-Excel loop.