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

I have the same question (0)

All responses (3)

Answers (0)

Gerardo Rentería Ga... 25,157 Most Valuable Professional on at

Like (1)

Report

Hi

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

Best

GR

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,329 Super User 2025 Season 2 on at

Like (2)

Report

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

Was this reply helpful? Yes No
Sivaguru Muralidharan 33 on at

Like (0)

Report

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?

Was this reply helpful? Yes No