How to Export Large Data from Power BI

Hitting Power BI's export limits is a frustratingly common roadblock. You've built a beautiful, insightful report, but now you need the raw data for a different analysis in Excel or another tool, and Power BI simply won't export all of it. This article walks you through several practical methods to get your large datasets out of Power BI, from easy built-in features to more advanced, powerful techniques.

Graphed

Still Building Reports Manually?

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

Watch the Demo

First, Why Does Power BI Have Export Limits?

Before jumping into the workarounds, it's helpful to understand why these limits exist. Power BI is primarily a data visualization and analysis tool, not a data extraction tool. The limits are in place to ensure:

• Performance: Exporting millions of rows can bog down the Power BI service, affecting performance for you and other users on a shared capacity.
• Stability: Unrestricted exports could strain server resources, leading to timeouts and instability.
• Intended Use: Microsoft encourages users to perform analysis within the Power BI environment, where the interactive experience is the main strength.

The most common limits you'll encounter when exporting from a visual in the Power BI service are:

• .xlsx (Excel): 150,000 rows max.
• .csv: 30,000 rows max.

These limits are often insufficient for deep-dive analysis. Let’s explore your options to get around them.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Method 1: Analyze in Excel

This is by far the easiest and most overlooked method for exporting large datasets to Excel, and it doesn't have the same row limitations. Instead of exporting a static file from a visual, "Analyze in Excel" creates a live connection from an Excel file directly to your Power BI dataset (what's sometimes called the semantic model).

This lets you use a PivotTable in Excel to pull in exactly the data you need from your model, handling hundreds of thousands or even millions of rows without breaking a sweat.

How to Use Analyze in Excel:

1. Navigate to your Power BI Dataset: Go to the Power BI service (app.powerbi.com), open the workspace containing your report, and go to the "Datasets + dataflows" tab.
2. Find your Dataset: Locate the dataset you want to export data from. Click the ellipsis (…) next to its name and select Analyze in Excel.
3. Download the Connector File: This will download a small file with an .odc (Office Data Connection) extension. You may need to install the Power BI OLE DB provider if you haven't already, Power BI will provide a link if you need it.
4. Open the File in Excel: Open the .odc file. Excel will ask for a security confirmation, click Enable. You'll now see a blank PivotTable on the left and your Power BI dataset fields in the "PivotTable Fields" pane on the right.
5. Build Your Table: Simply drag and drop the fields you need into the Rows, Columns, and Values areas. To get a flat table of raw data, just drag all the fields you want to export into the "Rows" area of the PivotTable Field sidebar. You can then right-click the PivotTable, go to "Show Values As," and format it as needed.

This method circumvents the export limits because Excel is querying the dataset directly, not downloading a static file generated by a visual.

Method 2: Use DAX Studio for Maximum Control

If you need millions of rows exported to a CSV or need more granular control, DAX Studio is your best friend. It’s a free, third-party tool that lets you connect directly to a Power BI data model running on your desktop and write Data Analysis Expressions (DAX) queries to extract data.

Don't be intimidated by the term "DAX query." For a simple export, the command is extremely easy.

Graphed

Still Building Reports Manually?

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

Watch the Demo

How to Export with DAX Studio:

1. Download and Install DAX Studio: You can find it by searching for "DAX Studio" online. It's a trusted tool in the Power BI community.
2. Open your PBIX File: First, open your report in Power BI Desktop.
3. Launch DAX Studio: Open DAX Studio. It will automatically detect your open PBIX file. A connection window will pop up, simply select the "PBI / SSDT Model" option with your file name and click Connect.
4. Write a Simple Query: In the main query window, you just need one command: EVALUATE. To get all the data from a table named "Sales," you would write:
5. Change the Output: Before running the query, look for the "Output" option in the Home tab. By default, it is set to "Grid". Change this dropdown to File.
6. Run the Query and Save: Now, click the "Run" button. Because you set the output to "File," DAX Studio will immediately prompt you to save the file. You can choose to save it as a CSV Text File or a Tab Delimited file. Choose your location and filename, and DAX Studio will export the entire table, even if it has millions of rows.

Method 3: Automate Large Exports with Power Automate

What if you need to run large exports on a schedule? That's where Power Automate comes in. You can build an automated workflow (called a "flow") that queries your Power BI dataset and saves the results to a file in SharePoint, OneDrive, or an email attachment.

This method requires a Power BI Pro license and some familiarity with Power Automate, but it’s incredibly powerful for setting up recurring reports.

Basic Steps for a Power Automate Flow:

1. Start in Power Automate: Go to make.powerautomate.com and create a new flow. A "Scheduled cloud flow" is perfect for recurring reports.
2. Add the Power BI Action: Search for the Power BI connector and select the action named Run a query against a dataset.
3. Configure the query:
4. Add an Action to Handle the Output: The Power BI action above gives you the data. Now you need to do something with it. A common step is to parse it into a usable format, like CSV. Add an action called Create CSV table and use the "First table rows" output from the previous Power BI step as the input.
5. Save the file: Finally, add a "Create file" action for your preferred cloud storage, like SharePoint or OneDrive. Use the output from the "Create CSV table" step as the file content and give it a dynamic name, such as Sales_Export_[timestamp].csv.

Once you run the flow, it will automatically query Power BI and save the full, unfiltered dataset as a CSV file in the location you specified.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Rethinking the Export: Do You Really Need It?

While these methods are effective, it’s always worth asking: do you truly need to export the data? Power BI's strength is its interactivity and its ability to serve as a "single source of truth." When you export data to Excel, you create a static, offline copy that immediately begins to age.

Consider these alternatives:

• Share the Report: Give stakeholders access to the Power BI report itself. Teach them how to use filters and slicers to explore the data on their own.
• Create Filtered Views: If users need specific data cuts, create pre-filtered views as separate pages or bookmarks within your report.
• Embed the Report: For wider access, you can embed the Power BI report in a SharePoint page, Microsoft Teams channel, or a custom application.

Final Thoughts

Working around Power BI's export limits is completely achievable. You can start with the simple and effective "Analyze in Excel" feature for most needs, or level up to DAX Studio or Power Automate when you need to handle massive datasets or automate your exports.

While mastering specialized tools like Power BI is incredibly valuable, we've found that one of the biggest bottlenecks for marketing and sales teams is the manual work that happens before data even makes it into a BI tool. If you feel like you spend more time chasing down CSVs from Google Ads, Shopify, and Salesforce than you do actually analyzing them, that's precisely why we built Graphed. We simplify the whole process by connecting to your platforms and letting you create real-time dashboards just by asking questions, saving you from the export-and-wrangle routine entirely.