Dynamics Business Central / NAV Developer Digest - Vol. 483
ArcherPoint’s Developer Digest focuses on Microsoft Dynamics 365 Business Central and Dynamics NAV development. This week’s volume includes how to access Business Central data in Fabric using Dataverse, Business Foundation, new in BC 2024 Wave 1, problems with Generic Charts in BC 2024 Wave 1, and using and abusing Edit in Excel.
The Dynamics 365 Business Central community, consisting of developers, project managers, and consultants, collaborates across various platforms to share valuable insights. At ArcherPoint, we greatly value their dedication and expertise. To ensure widespread access to this technical knowledge, we created Developer Digest.
Access Business Central data from Fabric using Dataverse
Bert Verbeek describes how users can create a shortcut between Fabric and Dataverse. By doing this, data will stay in Dataverse, but Fabric users can access and use the data.
Using Business Central’s native connection with Dataverse, users can conveniently share BC and Power Apps data to Fabric by connecting to Dataverse, avoiding the hassle of integrating with Fabric using API calls.
Read his blog, From Business Central to Dataverse to Fabric, to learn more.
Introducing Business Foundation, new in BC 2024 Wave 1
The Business Foundation, new in Business Central 2024 Wave 1, consolidates essential functions shared across Business Central into one application. The Business Foundation uses a modular architecture rather than a single, monolithic structure, which makes it easier to maintain and modify.
Alberto, the Business Central Geek, breaks down the Business Foundation in his blog, The New Business Foundation In Business Central.
Generic Charts in BC 2024 Wave 1
There was a time when Generic Charts were a helpful tool – use Business Central data to create a chart, save it in the table as a Generic Chart, then add it to a Role Center and refer to its properties programmatically.
Waldo describes an interesting problem when upgrading to the 2024 Wave 1 release of BC: the Role Center crashed – without compilation errors or telemetry indicating a problem.
It turns out that Generic Charts are still supported by Microsoft in Business Central…kinda sorta in a way. It appears in BC documentation, but you would be hard-pressed to actually use it. So, while no one probably uses Generic Charts anymore, it still might lurk in old custom code or third-party software – which could crash the Role Center.
Find out more. Read his blog, “Generic Charts” Forgotten, but not gone…
Using and abusing Edit in Excel
For some time, Business Central has supported the Edit in Excel feature. Edit in Excel lets users download Business Central data to Excel, make edits, and then publish their changes back to Business Central.
While this feature is convenient, it can also lead to bottlenecks when the Excel data is updated or inserted into the database. Excessive usage of this feature could cause performance and locking problems.
Stefano Demiliani describes this issue and provides a KQL query to check when and how your users are using Edit in Excel.
Read Dynamics 365 Business Central: Edit in Excel and Long Running SQL queries to learn more.
++++++++++++++++++++
Interested in Dynamics NAV and Business Central development? Be sure to see our collection of NAV/BC Development Blogs.
Read “How To” blogs from ArcherPoint for practical advice on using Microsoft Dynamics NAV and Dynamics 365 Business Central.