Announcements
No record found.
Hello Everyone, I tried pushing two hundred thousand records into business central(200000) , it doesn't allow me , is there a limit ??
How are you attempting it
with xmlport or Code written in a report to read this much records from excel or using a Configuration package?..
configuration packages
Please post screen shot of error
it may take some time but this much we have imported.
if on-premise then check with an increase in SQL timeout.
On Cloud, did not find any issue it took around an hour to import and then to apply data.
Share error
I don't think there is a limitation on configuration package. It's just that it will take a very long time to do it.
Configuration package is not a good way to import big data. Consider creating an xmlport. It is way faster.
I second Teddy Herryanto. Its very time consuming and its extremely frustrating when you get errors after import of tens of hours. XML ports is extremely fast. It imports within minutes and directly to actual table.
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
OussamaSabbouh 739 Super User 2026 Season 2
YUN ZHU 462 Super User 2026 Season 2
AndrewThomas81 406 Super User 2026 Season 2