SSRS 2014 Excel Export size limitation

Pierre Gourven 41 Reputation points

Hi everybody!

One of my customer use SSRS 2014 reports to generate Excel Exports which become larger than 30 Mo.
Which seems too big to me. I can't see clearly how he will work with Excel files as big as that.

Most of the time, he can make his export but he also regularly gets following error messages:
Microsoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException: An error occurred during rendering of the report. ---> Microsoft.ReportingServices.OnDemandReportRendering.ReportRenderingException: An error occurred during rendering of the report. ---> System.ObjectDisposedException: Store must be open for this operation.

Is there a maximum size for Excel export?
If I don't convince my customer to change his habits, is there a way to correct this problem?

Thanks for your help

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,854 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Olaf Helper 42,581 Reputation points

    See Export a paginated report to Microsoft Excel (Report Builder) for all supported export features and also the limitations.

  2. Isabellaz-1451 3,616 Reputation points

    Hi anonymous user ,

    Olaf pasted link display that the maximum number of rows is 1048576,is it possible that your report exceed the limit ?


    Best Regards,

    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.