Performance of the initial load to Dataverse from Business Central


The article discusses the performance of the initial data sync from Business Central to Dataverse. It explains that if you have a lot of columns and records in a table, the sync can be slow. The article provides information on how the sync works and suggests two workarounds for improving performance: using a manually written sync or importing data from Excel into Dataverse. The article also includes a setup and timing comparison for different methods. Overall, the article concludes that for tables with few columns, a full synchronization can still be used, but for tables with more columns, a manual sync or import from Excel is recommended.


Article 5w

Login now to access my digest by 365.Training

Learn how my digest works
Features
  • Articles, blogs, podcasts, training, and videos
  • Quick read TL;DRs for each item
  • Advanced filtering to prioritize what you care about
  • Quick views to isolate what you are looking for right now
  • Save your favorite items
  • Share your favorites
  • Snooze items you want to revisit when you have more time