Forum Discussion
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 a temporary system issue???
-
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...
-
8 Replies
Hey Pragati, Thank you for your response ☺, Like i said in the post, I have not made ant adjustments to the settings. Even doesn't know where the settings are, and I am not a techy enough to mess with that area.
Good day!
any chance you have exceeded the export data limit?
Is there a limit for this? 🤔
-
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...
-
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 KumarHi klaisjohn,
Just following up to see if the Response provided was 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
