We received the following error in the log file:

ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset

Turns out the export format was Excel and the output row count exceed 65k...