Graphed LogoGraphed
Graphed LogoGraphed
How It WorksAgentsIntegrationsPricing

How to Export Filtered Data from Power BI

Cody Schneider••9 min read

Your Power BI dashboard looks great - you’ve sliced, diced, and filtered your data to reveal a critical insight. Now you just need to get that specific, filtered view out of Power BI and into Excel for a teammate. This article walks you through a few different ways to export your filtered data from Power BI, from the simple and direct to a few clever workarounds for more control.

GraphedGraphed

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.

Watch Graphed demo video

Why Export Filtered Data from Power BI?

Power BI is an incredible tool for interactive analysis, but sometimes you need a static copy of a specific dataset. You might need to:

  • Share a specific subset of data with a colleague who doesn't have Power BI access.
  • Perform a quick, ad-hoc analysis in a spreadsheet without altering the main report.
  • Archive a snapshot of your data for a specific presentation or monthly report.
  • Use a filtered list to kick off another business process, like creating a call list for sales reps.

Whatever your reason, getting your filtered view out shouldn't be a chore. Let's look at the best ways to do it.

Method 1: The Standard Export from a Visual

This is the most common and straightforward method. It allows you to export exactly what you're seeing in a specific chart, table, or card after you've applied your filters or slicers.

Step-by-Step Instructions:

  1. Apply Your Filters: First, interact with your report just as you normally would. Use the slicers on the page, click on elements of one chart to cross-filter another, or use the Filters pane to narrow down your data to the precise view you want to export.
  2. Select a Visual: Hover your mouse over the visual (e.g., a bar chart showing sales by region, filtered for the last quarter) that contains the data you seek.
  3. Open More Options: In the top-right corner of the visual's container, you'll see an ellipsis button (…). This is the "More options" menu. Click on it.
  4. Choose "Export data": A dropdown menu will appear. Click on the "Export data" option. This will open a dialog box with a few choices.

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.

Understanding Your Export Choices: Summarized vs. Underlying Data

The dialog box presents you with two key options that dramatically change what you get. It's important to understand the difference.

Summarized data

Choosing this option exports the data exactly as it’s displayed in your visual. If your bar chart shows the total sales for five different regions, your exported file will have exactly five rows, one for each region, and a column with their total sales.

  • When to use it: This is perfect for when you need the high-level numbers that the chart is actively summarizing. It's clean, simple, and gives you the exact aggregated data used to build the visualization.
  • File format: You can usually choose between Excel (.xlsx) or Comma-Separated Values (.csv). Unless you have a specific need for CSV, Excel is often the better choice as it preserves more formatting.

Underlying data

This option is much more powerful. Instead of just exporting the summary, it exports all the raw data rows from your dataset that were used to calculate the visual, while still respecting all the filters you've applied. Using the same example, if a region's total sales came from 1,000 individual transactions, the "Underlying data" export would give you a file containing those 1,000 transaction rows.

  • When to use it: This is what you need when you want the granular details behind the summary. It's ideal for deep-dive analysis, creating custom pivot tables in Excel, or providing a colleague with the raw data for their own investigation.
  • File format: This option will often be available as an Excel (.xlsx) or .csv file. Be mindful of row limits here.

After choosing your preferred format, Power BI will generate the file and your browser will begin downloading it. That's it! You now have a perfectly filtered dataset ready for use elsewhere.

Method 2: Create a Dedicated "Export Table" Page

If you find that users of your reports are constantly asking how to export data, you can build a more user-friendly experience by creating a dedicated page just for this purpose. This gives you, the report designer, full control over exactly which columns can be exported, making for a cleaner and more intuitive process.

GraphedGraphed

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.

Watch Graphed demo video

Step-by-Step Instructions:

  1. Create a New Page: Add a new page to your Power BI report. Give it an obvious name, like "Data Export" or "Details Page." You can even hide this page from standard navigation if you want it accessible only via a button.
  2. Add a Table Visual: On this new page, add a Table visual. This will be your data staging area.
  3. Populate the Table: Drag all the fields you want users to be able to export into the "Columns" area of the table visual. This gives you precise control - you can include extra columns that might not be visible on your summary dashboards.
  4. Sync Your Slicers: This is the key step. Go to your main dashboard page, click on a slicer (e.g., for Date), go to the "View" tab on the ribbon, and click "Sync slicers." The Sync Slicers pane will appear. For your Date slicer, make sure the checkbox is ticked for both your primary dashboard page and your new "Data Export" page. Do this for every slicer you want to affect the export. Now, when a user makes a selection on the main page, that filter will also be applied to the table on your export page.
  5. Add a Navigation Button: Go back to your main report page. Insert a Button from the ribbon. In the button's "Action" settings, select "Page navigation" for the type and choose your new "Data Export" page as the "Destination." You can label the button something like "Export Detailed Data."

Now, your users have a clear and simple workflow: they apply their filters on the main dashboard, click the "Export" button, which takes them to a cleanly formatted table with all their filters applied, and from there they can use the standard "More options" (...) > "Export data" method. This technique gives them access to a rich dataset without cluttering your main visualizations.

Method 3: A Power User Trick with the Performance Analyzer

Sometimes you need to grab the data behind a visual that is very complex, or perhaps the standard export option is missing or limited. For these cases, you can use a clever trick with Power BI Desktop's Performance Analyzer to literally see and copy the DAX query that populates the visual.

Step-by-Step Instructions (in Power BI Desktop):

  1. Apply your filters on the report page as usual.
  2. Go to the View tab in the Power BI ribbon.
  3. Click on Performance Analyzer. A new pane will open on the right.
  4. Inside the Performance Analyzer pane, click Start recording.
  5. Now, interact with the visual you want to analyze. The easiest way is to click the Refresh visuals icon in the Performance Analyzer pane itself.
  6. The analyzer will show you a breakdown of how long each element on the page took to load. Find the name of your target visual in the list and expand its details by clicking the + icon.
  7. You’ll see a few components. The one you want is DAX query. Click the Copy query button right below it.

You now have the exact DAX query on your clipboard, with all the filtering logic from your slicers built in. You can now use this query in tools like DAX Studio to run it and export the results to a CSV or Excel file, giving you a very powerful way to access the raw data with no row limits imposed by the Power BI service.

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.

Important Limitations and What to Watch Out For

While an incredibly useful feature, exporting from Power BI has a few constraints you should be aware of.

  • Export Row Limits: Power BI is a data visualization tool, not a bulk data extraction tool. There are limits to how much you can export. From the Power BI Service:
  • Admin Settings Can Interfere: If you see the "Export data" option is grayed out completely, it's very likely that your Power BI administrator has disabled this feature for your organization or a specific sensitivity security group you're in. This is a common practice in companies dealing with sensitive information. If this is the case, you will need to talk to your IT or BI team about their data governance policies.
  • Export and Data Sensitivity: Remember that once data has left the secure environment of Power BI, it lives in a static file. That Excel sheet doesn't have the Row-Level Security (RLS) or permissions that govern who can see what in the original report. Be responsible with exported data, especially if it contains personally identifiable information (PII) or other sensitive business metrics.

Final Thoughts

Pulling specific, filtered data out of Power BI is a fundamental task for turning insights into action. Whether you're using the simple export command on a visual, designing a user-friendly experience with a dedicated export page, or using power tools to grab the underlying DAX query, you have flexible options to get the data you need into the format you want.

Our goal at Graphed is to eliminate the friction from this entire process. We built a tool that connects to all your data sources - like Google Analytics, Salesforce, and Shopify - and completely automates reporting. Instead of exporting data from one tool to analyze in another, we let you ask questions in plain English and instantly get back dashboards and answers. It removes the steps of filtering, exporting, and re-formatting, letting you go straight from question to insight in seconds.

Related Articles