Dynamics 365 Business Central
Category
Nov 25, 2024
Published date
Text
Article Type
AI Summary
- The 2024 wave 2 release (BC25) for Business Central makes it easier to connect Excel by removing the need to hardcode Tenant Ids and introducing named formulas.
- The hidden Aggregated Metadata sheet in BC25 Excel Report Layouts contains four tables, including the ReportRequestValues table with a new key TenantEntraId for identifying the connected tenant.
- With the new TenantEntraId value, Excel Reports can be used across different tenants and the layout can be loaded through an app install, making reports more reusable.
- Microsoft simplified connections by removing curly braces from around the Company Id, enhancing the user experience between BC24 and BC25.
- BC25 Excel Report Layouts now include named formulas to simplify complex XLookups or formulas, which can be viewed in the tab for Formulas > Name Manager.
- Microsoft recommends using XLookups or named formulas when referencing data in the Aggregated Metadata sheet to avoid breaking references during table tweaks like the addition of TenantEntraId in BC25.
- PowerQuery within Excel can be used to transform data before loading for user interaction, with variables to hold values from the Aggregated Metadata tables to build the complete URI for API calls to Business Central.
- Users can add parameters like SalesInvoiceNo to API calls for filtering, showcasing Microsoft's continuous evolution of reporting capabilities within Business Central.
Registered users can view the full text for FREE!
Sign In Now!