// troubleshooting guide · microsoft power bi
Power BI Export to Excel Limited to 150,000 Rows
- Status
- Ongoing
- platforms:
- Power BI service, Power BI Desktop
- updated:
- November 16, 2026
- reports:
- 3
- Method
- how we research
RUNBOOK · power-bi/export-more-than-150000-rows4 FIXES
// quick answer
Export data from a visual is capped at 150,000 rows to Excel and 30,000 to CSV. Use Analyze in Excel (live PivotTable on the model) or a query tool like DAX Studio to get more.
Most likely fix: Use Analyze in Excel
How to fix it
// try these in order, the most common fix is first
FIX 1Use Analyze in Excel
- 01In the Power BI service open the semantic model or report
- 02Select Export > Analyze in Excel
- 03Build a PivotTable connected live to the model
Did this fix it?FIX 2Export summarized data
- 01Choose Summarized data instead of Data with current layout
- 02Users report higher limits this way
Did this fix it?FIX 3Split the export
- 01Add a filter (for example by year or region)
- 02Export each slice separately
Did this fix it?FIX 4Query the model directly
- 01Install DAX Studio
- 02Connect to the semantic model (XMLA on Premium/Fabric or open .pbix in Desktop)
- 03Run an EVALUATE query and export results to CSV
Did this fix it?
SANDBOX · power-bi RUNS IN YOUR BROWSER
Try it: browse a sample shop and watch visitors, funnels and live data arrive
A hands-on Microsoft Power BI-style sandbox, including the spots where users get stuck. See where problems like this one start. 1-2 minutes, nothing is saved.
Symptoms
Exports stop at 150,000 rows (Excel) or 30,000 rows (CSV), or a matrix exports fewer rows than expected.
Why it happens
- C-01Built-in export limits on visuals
- C-02Matrix exports count data intersections, not rows
- C-03Tenant export settings set by admins
// this guide also covers
- power bi export more than 150000 rows
- power bi export to excel limit
- power bi export csv 30000 rows
- power bi export data limit
Still not working?
If Microsoft Power BI keeps failing, you're not alone. See every Microsoft Power BI problem users report or the alternatives people switch to.
Done fighting Microsoft Power BI? Our small team builds your own Microsoft Power BI alternative, or any software you need: web, mobile, games, desktop. Price agreed together.
Talk to usOther Microsoft Power BI errors
- Power BI Scheduled Refresh Failed
- Power BI Gateway Offline or Could Not Be Reached
- Why Is My Power BI Report So Slow?
- Power BI Desktop Refresh and Power Query So Slow
- Power BI Desktop Not Opening or Stuck on Splash Screen
- Can't Sign In to Power BI Desktop
- Power BI Visual Has Exceeded the Available Resources
- Power BI Error: The Key Didn't Match Any Rows in the Table