Skip to main content

Notifications

Announcements

🌸 Community Spring Festival 2025 Challenge & Updates🌸
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / How big data can I lor...
Small and medium business | Business Central, N...
Suggested answer

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

(1) ShareShare
ReportReport
Posted on by CU08052056-0 426
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
  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 46,918 on at
    How big data can I lord to a table through Configuration Package?
    You need to build xmlport which is much faster to load the big data compare to config package. 
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 27,647 Super User 2025 Season 1 on at
    How big data can I lord to a table through Configuration Package?
    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.
     
  • Suggested answer
    Holly Huffman Profile Picture
    Holly Huffman 5,534 on at
    How big data can I lord to a table through Configuration Package?
    Good morning, afternoon, or evening depending on your location!
     
    Key Considerations & Optimization Steps:
    1. 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.
    2. 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.
    3. 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.
    4. Run Imports During Off-Peak Hours
      • If your Business Central environment is heavily used, schedule imports during off-peak hours to avoid performance bottlenecks.
    5. 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.
    6. 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!

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

News and Announcements

🌸 Community Spring Festival 2025 Challenge & Updates🌸

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March 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... 294,118 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,866 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans