web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

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... / Best Approach to Uploa...
Small and medium business | Business Central, N...
Suggested Answer

Best Approach to Upload Large Volume Vendor Master Data (500K+) in Business Central

(2) ShareShare
ReportReport
Posted on by Sumit Singh 11,777 Super User 2026 Season 1

Hi Experts,

I am looking for suggestions on the most efficient way to upload a large volume of Vendor Master data (approximately 500,000 records) into Business Central.

Currently, I am using the Configuration Package, but it is quite time-consuming and requires processing data in chunks of around 10,000 records per upload.

Could you please recommend the best approach to handle such high-volume data loads? I am open to:

 

  • Standard tools or alternative methods available in Business Central

  • Performance optimization techniques

  • Customization or batch processing via technical development

  • Any external tools or APIs that can help improve efficiency
 

Thanks in advance for your guidance!

Categories:
Dynamics 365 Business Central
I have the same question (0)
  • Suggested answer
    Chris Hansen - RUX Profile Picture
    Chris Hansen - RUX 2 on at
    Hi!
     
    If it is a cloud instance I would try one of these tools. The Insight Works one is free and I've used it before. Not with your quantity of entries, but it was very fast
     
     
    RUX Data Imports and Migration: RUX
     
    Thanks,
    Chris
  • Suggested answer
    AndrewThomas81 Profile Picture
    AndrewThomas81 672 on at
    Breaking the data in chunks helps, which you have already done.
     
    I would also suggest removing any fields that you have not populated in the configuration package, even if a field is blank, Business Central is still going to validate that blank is an acceptable entry.  If you have a few of these per record, it can really add to the application time.
     
    You can also turn off validation per field, this will speed the process up, but have obvious drawbacks.
     
    Kind Regards
     
    Andrew Thomas FCCA MCP
    YouTube - Use Business Central
    LinkedIn
     

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,905 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 994 Super User 2026 Season 1

#3
Teagen Boll Profile Picture

Teagen Boll 668 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans