News and Announcements icon

Dynamics 365 CommunityForums Business Central forum Export to Excel Limit

Business Central forum

Suggested answer

Export to Excel Limit

(1) Share

Report

Report

Posted on by Sivaguru Muralidharan

16

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:

Integration with Teams, Excel, Outlook

Administration and permissions

All responses Img

All responses (3)

Answers Img

Answers (0)

Sivaguru Muralidharan 16 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 69,864 Super User 2024 Season 2 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 9,579 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

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 290,552 Super User 2024 Season 2

#2

Martin Dráb 228,552 Most Valuable Professional

#3

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans