Monday, 12 November 2018

Dynamics 365 Timeout - Unable to export data in Spreadsheet above 10,000 records

Dynamics 365 - Timeouts exporting above 10000 records.


Below is the solution to Extend the limit in CRM database

Check the Default value



select maxrecordsforexporttoexcel 

from Organization




Execute below query to extend the limit on OrgName_MSCRM
 
update Organization set maxrecordsforexporttoexcel=15000



Check the updated value using select query and do IIS reset.



In my case I have Account and Contacts 15000 records so in order to get these records export I have extended the download limit to 15000


Direct update in the SQL database can cause serious data loss so make sure you have database backup.