Dynamics 365 Business Central: Edit in Excel and Long Running SQL queries
Dynamics 365 Business Central has a feature called "Edit in Excel" that allows users to make changes to records in Excel and publish them back to Business Central. However, using this feature can result in long-running SQL queries and performance issues. The Excel add-in loads data using SQL queries and performs insert or update queries when data is updated in Excel. This can lead to increased long-running SQL queries, which can impact performance. It is important to be aware of this when using the "Edit in Excel" feature and monitor the usage to identify any potential issues.
Article 12m
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