Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

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

(1) ShareShare
ReportReport
Posted on by 38

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.

  • TB-30081649-0 Profile Picture
    TB-30081649-0 38 on at
    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 Profile Picture
    Jun Wang 7,604 Super User 2025 Season 1 on at
    A large data export (as a configuration package) to excel in Business Central
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 26,349 Super User 2025 Season 1 on at
    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. 
     
  • Verified answer
    gdrenteria Profile Picture
    gdrenteria 14,573 Most Valuable Professional on at
    A large data export (as a configuration package) to excel in Business Central
  • Suggested answer
    Khushbu Rajvi. Profile Picture
    Khushbu Rajvi. 8,877 Super User 2025 Season 1 on at
    A large data export (as a configuration package) to excel in Business Central

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,409 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans