How to Export More Than 150K Rows in Power BI

Hitting Power BI's 150,000-row export limit is a common frustration, especially when you need a complete dataset for a different tool or an in-depth analysis. This isn't a bug, it's a feature designed to protect the performance and stability of the Power BI service for all users. This article walks you through several practical methods to get all the data you need, well beyond the default limit.

Graphed

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.

Build Your First Agent

First, Why Does Power BI Have an Export Limit?

Before diving into the workarounds, it's helpful to understand why this limit exists. The Power BI service is a shared, multi-tenant environment. Exporting massive amounts of data is a resource-intensive task. To prevent one user's huge export from slowing down the service for everyone else, Microsoft put these governors in place.

The standard limits when exporting from a visual in the Power BI service are:

• Summarized Data (XLSX or CSV): What you see in the visual. The limits depend on the visual type and file format. For .xlsx, you can typically export up to 150,000 rows.
• Underlying Data (XLSX): Exports up to 30,000 rows from the data table(s) backing the visual. This option doesn't work for DirectQuery sources.
• Underlying Data (CSV): Exports a .csv file of up to 150,000 rows containing the underlying, unsummarized data from the tables used in the visual.

These limits are often enough for day-to-day use, but when you need to hand off a complete sales transaction log from the past year or do a granular customer behavior analysis in another system, 150,000 rows just won't cut it. Here are four effective ways to work around this.

AI Agents for Marketing

Crash Course

Graphed

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.

Download the PDF

Method 1: Connect with "Analyze in Excel"

This is often the quickest and easiest way to get your data into Excel without being constrained by the visualization limits. Instead of exporting data from a chart, you create a live connection from Excel directly to your Power BI dataset. This lets you work with up to Excel's limit of roughly one million rows.

When to Use This Method:

This is perfect for financial analysts, sales teams, or anyone who thinks and breathes in Excel. It's ideal for ad-hoc analysis, creating custom PivotTables, or when you just need a flat table of raw data to work with.

Step-by-Step Instructions:

1. Navigate to Your Report in Power BI Service: Open the workspace containing your report and click on the desired report.
2. Find the "Analyze in Excel" Option: In the menu bar at the top of the report, click on the "Export" dropdown, then select "Analyze in Excel." An .ODC (Office Data Connection) file will download.
3. Open the File: Locate the downloaded .ODC file and open it. Excel will prompt you with a security warning about data connections, click "Enable."
4. Build Your PivotTable: Excel will open with a blank PivotTable, and the PivotTable Fields pane on the right will show all the tables and measures from your Power BI dataset. You are now directly connected to the data model.
5. Create a Flat Table (The Trick to Getting All Rows): To get a full, unsummarized export, drag the descriptive fields (like Product Name, Order ID, Date, Customer Name, etc.) into the "Rows" area of the PivotTable Fields. Do not put anything in the "Values" or "Columns" areas.
6. Adjust an Important PivotTable Setting:

Method 2: Using the Table View in Power BI Desktop

Sometimes you don't even need to go to the Power BI service. If you have access to the original .pbix file, you can often extract a huge amount of data directly from Power BI Desktop, though you might be limited by your computer's RAM.

When to Use This Method:

Use this when you have the .pbix file handy and need a quick, no-frills copy of an entire table from your data model. It's a straightforward copy-and-paste job, perfect for smaller projects or machines with plenty of memory.

Graphed

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.

Build Your First Agent

Step-by-Step Instructions:

1. Open your .pbix file in Power BI Desktop.
2. Switch to Table View: On the left-hand side of the screen, click the icon that looks like a grid to switch to the "Table view."
3. Select Your Table: In the "Data" pane on the right, click on the name of the table you want to export. This will display all of its columns and rows in the main window.
4. Copy the Table: Right-click on the table name in the "Data" pane and select "Copy table." Alternatively, click the ellipsis (...) next to the table name.
5. Paste into Excel or a Text Editor: Open a blank Excel workbook or a text editor like Notepad++ and simply paste the data (Ctrl+V). Your entire table will appear. Wait for it to finish loading, which may take some time for very large tables.

Method 3: Leverage DAX Studio for Maximum Power

For truly massive datasets or for times when you need surgical control over what you export, DAX Studio is the ultimate tool. It's a free, external tool that connects to your Power BI model and lets you run DAX queries directly against it, outputting the results to a CSV file with virtually no row limit.

When to Use This Method:

This is the go-to solution for data analysts, BI developers, or power users who feel comfortable with query languages. It's incredibly powerful and reliable for exporting millions of rows without breaking a sweat.

Step-by-Step Instructions:

1. Download and Install DAX Studio: Head to daxstudio.org and download the installer. It’s a trustworthy community tool.
2. Open Your Report in Power BI Desktop: DAX Studio needs to connect to an open data model, so make sure your .pbix file is open first.
3. Launch and Connect DAX Studio: Open DAX Studio. It will automatically detect your open PBI file. Select "PBI / SSDT Model," ensure your file is selected in the dropdown, and click "Connect."
4. Write Your DAX Query: You don't need to be a DAX wizard for simple exports. To export an entire table, just write:
5. Choose the Output Destination: Before running the query, look for the "Output" section in the "Home" ribbon. The default is "Grid," which will display the results in DAX Studio. Change this to "File."
6. Configure File Output: Next to the dropdown where you selected "File," click on the settings icon or look for file options. Choose "CSV" as the format and select a location to save your file.
7. Run the Query: Click the "Run" button (or press F5). DAX Studio will execute the query and stream all the results directly to the CSV file you specified. You will see a progress bar and a final message once millions of rows have been successfully exported.

Method 4: Automate Large Exports with Power Automate

If you need to regularly create and send large data exports, manually running queries is inefficient. This is where Power Automate comes in. You can build an automated flow that queries your Power BI dataset on a schedule and saves the resulting CSV to SharePoint, OneDrive, or sends it in an email.

When to Use This Method:

This is for creating a repeatable, automated reporting process. For example, if you need to send a full transaction report to the finance team every Monday morning, this method saves you a ton of manual work. A Power Automate license is required.

AI Agents for Marketing

Crash Course

Graphed

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.

Download the PDF

High-Level Steps:

1. Start in Power Automate: Create a new "Scheduled cloud flow" and set your desired frequency (e.g., weekly on Monday at 7 AM).
2. Add a Power BI Action: Search for the Power BI connector and select the action named "Run a query against a dataset."
3. Configure the Query: Select the Workspace, Dataset, and then paste in a DAX query just like in the DAX Studio method. This query defines what data will be pulled.
4. Convert to CSV: Add a new action step called "Create CSV table" from the "Data Operation" connector. Use the "First table rows" output from the previous Power BI step as your input.
5. Save the File: Add a final action step to save the file. For example, use the connector for SharePoint and choose the "Create file" action. Specify the site address, destination folder, a file name (you can use dynamic content to add the date, like SalesExport-utcNow().csv), and finally, use the output from the "Create CSV table" step as the file content.

Once saved and activated, this flow will run automatically, exporting massive datasets from Power BI without you ever having to lift a finger.

Final Thoughts

Power BI's export restrictions can feel like a roadblock, but they're manageable once you know which tool to use for the job. From the easy "Analyze in Excel" for quick analysis to the robust power of DAX Studio or the automation of Power Automate, there is always a way to get the data you need for your downstream tasks.

Having to regularly export huge datasets often points to a larger operational slowdown: your marketing and sales data is fractured across platforms, and answering simple questions requires manual, time-consuming data pulls. At Graphed, we help you solve this core problem. We connect directly to all your sources - like Google Analytics, Shopify, Facebook Ads, and Salesforce - and bring your data into one unified space. Instead of spending hours pulling CSVs, you just ask questions in plain English to build real-time dashboards, freeing you up to act on insights instead of just gathering them.