cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
elitekrishnan
Frequent Visitor

Power BI Report Server SSRS Report Export to Excel Error

Hi,

 

I have hosted the SSRS Report in Power BI Report Server that report output has nearly 1900 pages.

For exporting in to excel, I have created Subscription and delivery as “Windows File Share” in Power BI Reporting portal.

When the subscription schedule starts immediately  it goes to “Pending” status and getting the below error message in the Report Server log file.

Unhandled error in the Web API. Exception: System.Net.Http.HttpRequestException: Error while copying content to a stream. ---> System.IO.IOException ---> System.Net.HttpListenerException: The I/O operation has been aborted because of either a thread exit or an application request

 

Please advise, how to resolve this export issue and is there any config setting to update to get the large number of records export to file?

 

Thanks,

 Navaneethakrishnan Thangaraj

1 REPLY 1
HashamNiaz
Super User
Super User

Hi @elitekrishnan !

It seems like you are running into Memory / Excel export limitation with your SSRS report. See the MS docs below;

 

Excel Limitations 

You can try exporting the report directly by browsing through the report & see if it works, make sure your system has enough available RAM to hold 1900 pages.

 

Regards,

Hasham

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.