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.