How big data can I lord to a table through Configuration Package?

(6) Share

Report

Posted on by CU08052056-0

1,187

Hi experts!

I would like to lard large address data into a table through configuration package; however, it is very slow when Applying data to Package. How can I lord that quickly?

Lookking forward to hearing from you.
Nobuhara

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (8)

Answers (2)

Suggested answer

Holly Huffman 6,538 Super User 2025 Season 2 on at

Like (5)

Report
Good morning, afternoon, or evening depending on your location!

Key Considerations & Optimization Steps:

Split Data into Smaller Batches

Instead of importing all records at once, break the data into smaller chunks (e.g., 20,000 records per batch).

This reduces processing time and minimizes system strain.

Use XMLPorts for Bulk Imports

Configuration Packages are convenient but can be slow for large datasets.

XMLPorts provide a structured and efficient way to import bulk data, significantly improving performance.

Optimize Table Indexing

Ensure that the target table has appropriate indexing to speed up data processing.

If possible, disable unnecessary validations during import and re-enable them afterward.

Run Imports During Off-Peak Hours

If your Business Central environment is heavily used, schedule imports during off-peak hours to avoid performance bottlenecks.

Consider Alternative Import Methods

Some users have reported better results using third-party import/export tools like Import-Export PowerTool or Power Automate-based solutions.

These methods can bypass some of the limitations of Configuration Packages.

Check for System Constraints

Ensure that your Business Central environment is not running unnecessary extensions that could slow down performance.

If the process is stuck, verify if there are any system locks or background jobs interfering with the import.

Hope this helps some!

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 31,481 Super User 2025 Season 2 on at

Like (5)

Report

The only thing you can do with configuration packages is to remove the validation. If you go to Table -> Fields, you can uncheck the validation for each field and that should speed it up. But if you do this you have to ensure the data you're loading is correct as the system won't validate it. Otherwise, you can use another solution such as a custom built xml port.

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

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,245 Super User 2025 Season 2 on at

Like (5)

Report

You need to build xmlport which is much faster to load the big data compare to config package.

Was this reply helpful? Yes No
Suggested answer

Ramesh Kumar 7,529 Super User 2025 Season 2 on at

Like (4)

Report

Totally hear you — loading large address data through a Configuration Package in Business Central can get painfully slow. I would suggest disable Data Validation Temporarily

Thanks!

Ramesh

If this was helpful, please check the "Does this answer your question?" box and mark it as verified.

Was this reply helpful? Yes No
Verified answer

YUN ZHU 95,729 Super User 2025 Season 2 on at

Like (4)

Report

There is no limit on Configuration Package. But I remember Microsoft mentioned that using Configuration Package will be slow when processing large data.

This looks like a custom table, you might also consider customizing a simple tool to import Excel.

Microsoft Dynamics 365 Business Central: How to use Excel Buffer to Import data

https://yzhums.com/4223/

Hope this helps as well.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Jainam M. Kothari 15,639 Super User 2025 Season 2 on at

Like (4)

Report

Hello,

By way of Configuration Package, if you are processing Bulk Large data then yes the System Performance will be slow.

But if you Split the Large Data in Smaller parts like in 1 lac. Then it will be Process Faster and Savings the Time.

Or else as mentioned by Experts, you can use Xml Port or any other things to update the data.

Was this reply helpful? Yes No
Verified answer

YUN ZHU 95,729 Super User 2025 Season 2 on at

Like (3)

Report

PS: Using configuration packages to import large amounts of data can impact performance and prevent all users from using Business Central during the process.
https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/administration/apply-company-configuration-packages?wt.mc_id=DX-MVP-5004336#migrate-customer-data

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 20,601 Super User 2025 Season 2 on at

Like (4)

Report

Adding more details: https://community.dynamics.com/forums/thread/details/?threadid=69af3089-9a09-4523-ad18-6e9c1bddd907

https://community.dynamics.com/forums/thread/details/?threadid=56c82e4b-f066-ef11-bfe2-000d3a4e9b05

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/administration/set-up-standard-company-configuration-packages

Was this reply helpful? Yes No