A large data export (as a configuration package) to excel in Business Central

(1) Share

Report

Posted on by TB-30081649-0

I am trying to export a large configuration package (457,000 lines)
from Business Central (cloud) to Excel. The configuration package
contained one filter (<>0) on one field in the table . It times
out at between 360,000 and 380,000 lines each time. During some
attempts, I would get the error message that the connection needed to be
reestablished and during other attempts, it would simply stop
responding but with no error message.

Version: US Business Central 24.4 (Platform 24.0.23306.0 + Application 24.4.22295.22393)

Any suggestions on how to export large reports/data?

I tested changing the filter which worked because it resulted in a
reduction in lines. I also reduced the number fields, which also worked
because it reduced the size of the export. But, I need all of the
lines from my original filter and all of the fields in the report. I've
looked at Microsoft documentation but solutions around exporting the
database and task scheduler don't seem to apply.

Categories:

Dynamics 365 Business Central

All responses (5)

Answers (1)

TB-30081649-0 38 on at

Like (1)

Report

A large data export (as a configuration package) to excel in Business Central

thank you to all of you who responded. It's greatly appreciated. I'm going to try the Power Automate, Graph API solution suggested.

thanks again!
Suggested answer

Jun Wang 8,051 Super User 2025 Season 1 on at

Like (0)

Report

A large data export (as a configuration package) to excel in Business Central

for your reference

https://demiliani.com/2023/10/09/dynamics-365-business-central-and-large-data-export-to-excel-via-power-automate-use-graph-api/
Suggested answer

Valentin Castravet 28,290 Super User 2025 Season 1 on at

Like (0)

Report

A large data export (as a configuration package) to excel in Business Central

The most efficient way would be to get a developer to build a custom xmlport.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/
Verified answer

Gerardo Rentería Ga... 21,118 Most Valuable Professional on at

Like (0)

Report

A large data export (as a configuration package) to excel in Business Central

Hi

I hope this can help you and give you some hints.

Dynamics 365 Business Central and large data export to Excel via Power Automate: use Graph API. – Stefano Demiliani

Best

GR
Suggested answer

Khushbu Rajvi. 17,526 Super User 2025 Season 1 on at

Like (1)

Report

A large data export (as a configuration package) to excel in Business Central

Hi, Here is answer of your question: https://community.dynamics.com/forums/thread/details/?threadid=69af3089-9a09-4523-ad18-6e9c1bddd907

Hope its help