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
Icon for Responsive Resident rankResponsive Resident
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!

  • Baji_Gunturu's avatar
    Baji_Gunturu
    Regular Visitor
    6 months ago

    Thanks RicardoTraNa ..
     I have used Data With Current Layout with this getting only 50K rows..you are saying use Underlying datat.. so if i use that, will it exports till 150K .. and Underlying data is disabled.