topic Compressing excel file for Export in Report Server in Report Server

Compressing excel file for Export in Report Server

M_nwadibia — Tue, 19 Sep 2023 13:25:00 GMT

Hello,

I have a file size limit in our email configuration and my file keep growing.

Is there an option to compress large excel files in Report Server or RDL so that emailing can be easier using RDL authoring tool?

The report in question has about 9 columns only but has over 400k records and size 25MB. The mailing limit is 22MB.

Thank You

Re: Compressing excel file for Export in Report Server

d_gosbell — Wed, 20 Sep 2023 00:52:34 GMT

The Excel files should already have compression applied. I do not believe there are any settings to increase the amount of compression. You might need to look at using a different transport mechanism such as putting the files in a file share.

Re: Compressing excel file for Export in Report Server

M_nwadibia — Wed, 18 Oct 2023 14:53:00 GMT

I understand we can use Python to convert the .xlsx to xlsb or PowerShell Programs before using standard subscription to distribute report. Is this possible?

Re: Compressing excel file for Export in Report Server

miwundu — Sat, 13 Sep 2025 19:30:57 GMT

I tried file share but the report fails to render. Everyother report less than 22MB executes except this one above 22mB which exceeds the outlook set limit.

Re: Compressing excel file for Export in Report Server

mjsystemss — Mon, 15 Sep 2025 13:41:21 GMT

I think MS should consider including Zip Option as export option when doing subscription in report server

Re: Compressing excel file for Export in Report Server

d_gosbell — Mon, 15 Sep 2025 21:43:32 GMT

mjsystemss wrote:

I think MS should consider including Zip Option as export option when doing subscription in report server

The xlsx format is already zipped internally. Zipping it again will not make any significant difference

Re: Compressing excel file for Export in Report Server

mjsystemss — Tue, 16 Sep 2025 12:22:23 GMT

I have resolved this. I embedded this as a link in sharepoint and shared the link with Users. It runs well now.