Forum Discussion

Baji_Gunturu's avatar
Baji_Gunturu
Regular Visitor
6 months ago
Solved

Unable to export 90K rows in Matrix visual

Hi Teams, I'm using Matrix visual with rows fields section like 7 fields , column filed section with one filed and in values section 4 measures and i have filtered for 2025-Jan Data which has aaroun...
Need Help
  • RicardoTraNa's avatar
    RicardoTraNa
    6 months ago

    Hey! Power BI has export limits: summarized data from a visual allows up to 30,000 rows, while underlying data allows up to 150,000 rows. Your Matrix visual likely exported summarized data, which is why only 57K rows appeared. To get all 80–90K rows, export the underlying data instead.

    Hope that help!

RicardoTraNa's avatar
RicardoTraNa
Responsive Resident
6 months ago

Hi!  Yes, using “Underlying data” would let you export up to 150K rows instead of the  50K you get with “Data with current layout.”

However, if Underlying data is disabled, it’s usually because the dataset owner turned off that option, or there are restrictions like DirectQuery sources or row-level security.
Unfortunately, you can’t enable it yourself.

Workarounds are to ask the dataset owner to allow underlying data export, or to export smaller chunks using filters (like by date or region) so you stay within the summarized data limit.

hope that helps