Small and medium business | Business Central, N...

Export to Excel Limit

(1) Share

Report

Posted on by Sivaguru Muralidharan

What is the limit on Export to Excel in Business Central? is it 50,000?

We recently upgraded a database from Version 22 to 24 On-Prem., and we were comparing some data between the 2 databases (old 22 DB and new 24 DB) and saw that in the 22 Version database, we were able to export around 370,000 records from a table. for the same table in the 24 Database, we got an error stating that the number of records was too high.

Did something change in Version 24 or am I missing something here?

Categories:

Dynamics 365 Business Central

All responses (3)

Answers (0)

Sivaguru Muralidharan 33 on at

Like (0)

Report

Export to Excel Limit

Thanks for giving me some insight on this topic, but any idea which server instance/ config settings I should take a Look at?

The MaxRowsToExportToExcel is set to MaxValue. Any idea what the Max Value is?
Suggested answer

YUN ZHU 78,476 Super User 2025 Season 1 on at

Like (2)

Report

Export to Excel Limit

Hi, As far as I know there is no limit. There are two relevant information.

1.

https://learn.microsoft.com/en-us/dynamics365/business-central/faq-copy-paste?wt.mc_id=DX-MVP-5004336#what-is-the-maximum-number-of-rows-that-can-be-copied

2. https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/administration/operational-limits-online?wt.mc_id=DX-MVP-5004336

You can check the server settings to see if they are different from the previous version.

Hope this helps.

Thanks.

ZHU
gdrenteria 14,976 Most Valuable Professional on at

Like (1)

Report

Export to Excel Limit

Hi

I hope this can help you: Analyzing Report Data with Excel and XML - Business Central | Microsoft Learn

Best

GR