Dynamics Business Central / NAV Developer Digest - Vol. 462
ArcherPoint’s Developer Digest focuses on Microsoft Dynamics 365 Business Central and Dynamics NAV development. This week’s volume includes new reporting and BI coming in Business Central, memory issues using Azure functions and blob triggers, and potential problems with Open In Excel.
The Dynamics 365 Business Central community comprises professionals devoted to advancing the success of their customers. Developers, project managers, and consultants collaborate to share helpful information across blogs, forums, and social media sites. From discovering new solutions to finding answers to complex issues, these dedicated individuals are constantly sharing their knowledge with others. At ArcherPoint, we recognize and appreciate this highly engaged community’s creativity, hard work, and collective intelligence. To ensure all users can benefit from their expertise, we want to share their wealth of information with everyone.
New reporting and BI is coming for Business Central
Jason Gumpert of MS Dynamics World reports from Directions EMEA 2023 that Microsoft intends to improve the reporting features of Business Central, including better self-service reporting and analytics, Excel reports, and Power BI.
According to Microsoft principal program manager Kenny Nybo Pontoppidan speaking at the event, the BC team will deliver 30 new Excel-based reports between the current release (v23) and v25. Product areas for the new reports include finance, sales, customers, and vendor and purchase inventory. Microsoft also plans to deliver new Power BI apps covering all domain areas of BC in versions 24, 25, and 26.
Azure functions, blob triggers, and memory usage
When using the Blob storage trigger with Azure Functions, you can choose from various bindings: Stream binding, BlobClient binding, Byte array binding, and String binding.
However, depending on which binding you choose, the content of the blob triggering the function can be fully loaded into memory, potentially creating OutOfMemoryExceptions when processing files.
Stefano Demiliani addresses this problem and offers a solution in his blog, Azure Functions and Blob Triggers: be careful on the binding type.
Is Open In Excel causing you problems?
Open In Excel is a favorite feature in Business Central, but it can cause problems – even freeze operations – if you’re not careful.
Duilio Tacconi encountered such a case. Tacconi explains how he drilled down to uncover the underlying problem using telemetry and offers a solution to the problem.
Read Duilio Tacconi’s blog, Open In Excel can lead to a high-locking scenario, to find out 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.