// 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
Share

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

  1. FIX 1Use Analyze in Excel

    1. 01In the Power BI service open the semantic model or report
    2. 02Select Export > Analyze in Excel
    3. 03Build a PivotTable connected live to the model
    Did this fix it?
  2. FIX 2Export summarized data

    1. 01Choose Summarized data instead of Data with current layout
    2. 02Users report higher limits this way
    Did this fix it?
  3. FIX 3Split the export

    1. 01Add a filter (for example by year or region)
    2. 02Export each slice separately
    Did this fix it?
  4. FIX 4Query the model directly

    1. 01Install DAX Studio
    2. 02Connect to the semantic model (XMLA on Premium/Fabric or open .pbix in Desktop)
    3. 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 us

Watch Microsoft Power BI Get an email when its price changes, it has an outage, or we publish a new fix. No spam.

Fixed it? Share this guide

Other Microsoft Power BI errors

All 14 Microsoft Power BI errors and fixes →