Microsoft Dynamics 365 Business Central just got a powerful upgrade in its 2025 Wave 1 (BC26.2) release โ especially for data enthusiasts and power users.
With the new feature, you can now add fields from related tables directly within Analysis Mode, offering a richer and more flexible way to dive into your business data. No more switching views or crafting complex reports โ itโs all available within the analysis interface.
The update enables users to:
โ
Insert fields from related tables seamlessly
โ
Keep your analysis within one screen
โ
Choose the insertion point โ either at the end or next to a selected column
โ
Analyze master and transactional data side-by-side
๐ธ Simply click the drop-down arrow next to the Analysis View title, then select “Add columns from” to choose a related table.
๐ธ After selecting the related table (e.g., Sales Header), you’ll be presented with a list of fields to add.
๐ Whether youโre tracking sales patterns, customer behaviors, or item-level performance, this feature is your new best friend.
Imagine you’re analyzing Sales Lines and want to include customer details or document types from the Sales Header. Previously, this required setting up separate pages or queries.
Now? A few clicks, and the data is in your view โ live, filterable, and sortable.
Microsoft has released a helpful demo walking you through this enhancement: ๐
Want to see it in action? Microsoftโs official walkthrough video shows exactly how this feature works.
This isnโt just a UI tweak โ itโs a data accessibility breakthrough for users who live inside Business Central.
๐งฉ No need for dev help or custom reports
๐งฎ More context in every analysis
๐ Smarter, faster decisions
๐ค Export to Excel or continue slicing and dicing right inside BC
Microsoft continues to double down on user empowerment and data democratization with features like this.
Have you tried the new โAdd columns from related tablesโ yet? What new insights did it help you unlock?
Letโs talk ๐
Office No 1408, Tiffany Towers, Cluster W, Jumeirah Lake Towers, Dubai, United Arab Emirates