SSRS 2016 When Export the data Excel for sometimes the error Excel Rendering Extension : Argument is not valid popping up

Question

SSRS 2016 When Export the data Excel for sometimes the error Excel Rendering Extension : Argument is not valid popping up

An error occurred during rendering of the report. (rrRenderingError)
An error occurred during rendering of the report.
Excel Rendering Extension : Argument is not valid.

this issue also observing since previous versions of SSRS .

Hope some one know the possible solution to fix.

Answer 1

Hi @Ravishanker Maduri ,
Does this happen to all reports? You can try to export a very simple report for testing.

If this phenomenon also exists in earlier, it has to be considered the problem of the report itself.

An error occurred during rendering of the report. (rrRenderingError)

This message is returned when Reporting Services cannot render or export the report.

There are usually some limitations when exporting reports to Excel. You can refer to the following links for troubleshooting: Export a paginated report to Microsoft Excel (Report Builder).

For more information about this error, see: rrRenderingError - Reporting Services Error

Best Regards,
Joy

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
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.