Forum Discussion

klaisjohn's avatar
klaisjohn
New Member
10 months ago
Solved

Exporting to Excel Isue

  I am getting this message when attempting to export data, I could export data before. I didn't change any settings.  Any assistance/advise would be very helpful☺. Could this potentially be ...
  • zenisekd's avatar
    zenisekd
    10 months ago

    • When exporting data from a report visual to .xlsx (Excel), the maximum number of rows you can export is 150,000.

    • When exporting to .csv, the limit is 30,000 rows. 

    • For matrix visuals exporting with “Data with current layout”, the limit is 150,000 data intersections. Because a “row” in a matrix can have multiple intersections, the effective number of rows you see in Excel may be smaller. 

    • When using DirectQuery, there is an additional limit: the export request is capped at 16 MB uncompressed data. This can further reduce the number of rows you actually can export.

       

      However, usually you get a friendly warning that the rows have been reduced for the export...
Anonymous's avatar
Anonymous
Not applicable
10 months ago

Hi klaisjohn,

 

Thank you for reaching out to the Microsoft Fabric Forum Community, and special thanks to Pragati11 and zenisekd  for prompt and helpful responses.

 

Just following up to see if the Response provided by community members were helpful in addressing the issue. if the issue still persists Feel free to reach out if you need any further clarification or assistance.

 

Best regards,
Prasanna Kumar