Hi, Readers.
Dynamics 365 Business Central 2025 wave 1 (BC26) is generally available. More details: General Available: Dynamics 365 Business Central 2025 release wave 1 (BC26).
And minor update 26.2 for Business Central 2025 release wave 1 has been released for Business Central online. More details: Cumulative Update Summary for Microsoft Dynamics 365 Business Central (June, 2025)

I will continue to test and share some new features that I hope will be helpful. In this version, a long-awaited new feature is released.
Add fields from related tables in analysis mode:
Business value:
https://learn.microsoft.com/en-us/dynamics365/release-plan/2025wave1/smb/dynamics365-business-central/add-fields-related-tables-analysis-mode?wt.mc_id=DX-MVP-5004336
Analysis mode is a powerful experience that lets you create and analyze data views easily. You can also use Copilot and natural language to create views. This release lets you add fields from related tables to an analysis mode tab, including grouping by these fields for advanced data analysis.

“Analysis mode” is a feature that allows users to interact with data on lists in a way that’s optimized for data analysis, enabling them to create detailed pivot tables, reports, and analysis views directly from the same page, without needing to run separate reports or switch to other applications. It was introduced as a public preview feature in 2023 release wave 1 (BC22), and provided a new way to interact with data on list pages. More details: Analyze, group, and pivot data on list pages using multiple tabs (In-client Analysis mode)

Since then, Microsoft has continued to update this feature.
- Business Central 2023 wave 2 (BC23): Analyze, group, and pivot data on queries using multiple tabs (In-client Analysis mode in Query)
- Business Central 2023 wave 2 (BC23): Turn off data analysis mode on pages and queries (AnalysisModeEnabled Property and Allow Data Analysis Mode permission)
- Business Central 2023 wave 2 (BC23.1): The AnalysisModeEnabled property is now supported on pages of type Worksheet
- Business Central 2023 wave 2 (BC23): Share a data analysis with a co-worker (Copy link in the Analysis mode)
- Business Central 2024 wave 1 (BC24): Get to insights fast with Copilot-created analysis tabs (Analysis mode)
- Business Central 2024 wave 2 (BC25): Experience enhancements to analysis assist with Copilot
With this wave, Microsoft brings us another revolutionary update, we can now add fields from related tables in analysis mode. Let’s see more details.
You can add fields from related tables in analysis mode tabs in two ways:
- From the context menu Add columns from on an analysis mode tab. This inserts the fields as new columns at the end of the view.

- From the context menu Add columns from on an analysis mode column. This inserts the fields as new columns to the right.

In both cases, select the related table to choose fields from. If there is more than one relation to the target table, the context menus show via <relation>
after the table name.

After you select the table, a dialog appears to choose columns. The dialog shows the source table name, as well as the fields in the table.

You can only select fields that have already been added to one or more pages. Use the Show available fields from option to select a page, which then populates the available table fields.

You can add multiple fields at once using multiselect. User-defined views are personal and reside in the tenant database.

Choose Continue.
You are about to add related table fields…
For the best performance, we need to limit filtering, sorting, and pivoting on calculated fields. To maintain full functionality, remove the added related fields. Also, exporting data to Excel will include just what is on screen.

Very simple.

Let’s look at another example, in an analysis mode tab on the Customer list, you can add fields from the Contact table. But the Contact table is not directly displayed in the list, select Other source…

All associated tables will be displayed in Insert column(s) page.

You can also enter keywords to search directly.

After selecting Source table, you can see the Choose the columns to insert area, which is the same as in the first example.




After adding, you can click Remove releated columns action to remove all releated columns.

Very simple, although this is limited to analysis mode, it is a step further than Smartlist. Give it a try!!!😁
PS:
1. What’s new: Data analysis
2. This feature was released in BC26.1 On-Premises in advance

My test version: W1 26.1 (Platform 26.0.33865.0 + Application 26.1.33404.33876)

END
Hope this will help.
Thanks for reading.
ZHU
コメント