web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Export to Excel Limit

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

Suggested Answer

Export to Excel Limit

(1) Share

Report

Report

Posted on by Sivaguru Muralidharan

33

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

Dynamics 365 Business Central

Dynamics 365 Business Central

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (0)

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

Like (1)

Report
Copy link

Link copied!

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 99,086 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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

Join the conversation

Helpful resources

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

OussamaSabbouh 1,993 Super User 2026 Season 1

#2

YUN ZHU 1,116 Super User 2026 Season 1

#3

Khushbu Rajvi. 557 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans