---
id: video/SHOAw9GehdI
type: video
title: "What's New: Data Analysis (2025 release wave 2)"
summary: "Business Central data analysis (analysis mode) in the 2025 release wave 2: Analysis Assist Copilot can add fields from related tables, server-side mode can pivot on date hierarchy, and right-click menu options were added. Flow fields cannot be calculated server-side."
tier: official
language: en
tags:
  - data analysis
  - analysis mode
  - copilot
  - analysis assist
  - pivot
  - date hierarchy
  - ad hoc analysis
  - server-side loading
  - productivity improvements
system: reporting
review:
  state: reviewed
  by: opus
  at: "2026-10-07T22:54:20.931Z"
  flags: []
generated:
  at: "2026-10-13T00:32:41.360Z"
  pipeline: 0.2.0
  prompts:
    extract-video: 1
    summarize-video: 2
  input_hash: c3c999ddac12d4f326311075ccad060a6d351790b8417a788c0c2cd6d92cb0a7
evidence:
  - kind: video
    url: https://www.youtube.com/watch?v=SHOAw9GehdI&t=16s
    title: "What's New: Data Analysis (2025 release wave 2)"
    date: "2025-10-01T00:00:00Z"
    commit: null
    t: 16
    quote: more than 70% of all Business Central customers use data analysis, also known as analysis mode
  - kind: video
    url: https://www.youtube.com/watch?v=SHOAw9GehdI&t=38s
    title: "What's New: Data Analysis (2025 release wave 2)"
    date: "2025-10-01T00:00:00Z"
    commit: null
    t: 38
    quote: we even added a great co-pilot experience a couple of releases back so that you can also use natural language
  - kind: video
    url: https://www.youtube.com/watch?v=SHOAw9GehdI&t=211s
    title: "What's New: Data Analysis (2025 release wave 2)"
    date: "2025-10-01T00:00:00Z"
    commit: null
    t: 211
    quote: we have now ability for analysis assist to also add fields from tables that are related to what you're using here
  - kind: video
    url: https://www.youtube.com/watch?v=SHOAw9GehdI&t=260s
    title: "What's New: Data Analysis (2025 release wave 2)"
    date: "2025-10-01T00:00:00Z"
    commit: null
    t: 260
    quote: there are few things we you can't do such as flow fields things that are calculated
  - kind: video
    url: https://www.youtube.com/watch?v=SHOAw9GehdI&t=272s
    title: "What's New: Data Analysis (2025 release wave 2)"
    date: "2025-10-01T00:00:00Z"
    commit: null
    t: 272
    quote: One of the things you could not do in serverside mode until this release is pivoting on date hierarchy
  - kind: video
    url: https://www.youtube.com/watch?v=SHOAw9GehdI&t=340s
    title: "What's New: Data Analysis (2025 release wave 2)"
    date: "2025-10-01T00:00:00Z"
    commit: null
    t: 340
    quote: the third feature I wanted to show you is that we have some productivity improvements on the menu here
links:
  learn: []
  objects: []
  features: []
  topics: []
  localizations: []
  videos: []
  posts: []
  guidelines: []
video_id: SHOAw9GehdI
channel: yt-microsoft
source_name: Microsoft Dynamics 365 Business Central (YouTube)
url: https://www.youtube.com/watch?v=SHOAw9GehdI
published_at: "2025-10-01T00:00:00Z"
duration_s: 689
captions: full
audience:
  - end user
  - functional consultant
  - administrator
chapters:
  - t: 0
    title: Introduction to Data Analysis and Analysis Mode
  - t: 87
    title: Copilot Demo - Adding Fields from Related Tables
  - t: 211
    title: Server-Side Loading and Field Limitations
  - t: 272
    title: Pivoting on Date Hierarchy in Server-Side Mode
  - t: 340
    title: Productivity Improvements and Right-Click Menu
  - t: 426
    title: Summary of Three New Features
  - t: 474
    title: Learning Resources and Documentation
  - t: 564
    title: Community Resources and Closing
features:
  - name: Analysis Assist Copilot
    status: unclear
    t: 38
    verified: false
    status_source: video
  - name: Add Columns from Related Tables
    status: unclear
    t: 211
    verified: false
    status_source: video
  - name: Server-Side Data Loading
    status: unclear
    t: 232
    verified: false
    status_source: video
  - name: Pivot on Date Hierarchy in Server-Side Mode
    status: unclear
    t: 272
    verified: false
    status_source: video
  - name: Right-Click Menu for Data Analysis
    status: unclear
    t: 340
    verified: false
    status_source: video
  - name: Data Analysis Feature
    status: unclear
    t: 16
    verified: false
    status_source: video
objects_mentioned: []
quotes:
  - t: 16
    text: more than 70% of all Business Central customers use data analysis, also known as analysis mode
    check: exact
  - t: 38
    text: we even added a great co-pilot experience a couple of releases back so that you can also use natural language
    check: exact
  - t: 211
    text: we have now ability for analysis assist to also add fields from tables that are related to what you're using here
    check: exact
  - t: 260
    text: there are few things we you can't do such as flow fields things that are calculated
    check: fuzzy
  - t: 272
    text: One of the things you could not do in serverside mode until this release is pivoting on date hierarchy
    check: exact
  - t: 340
    text: the third feature I wanted to show you is that we have some productivity improvements on the menu here
    check: exact
---

# What's New: Data Analysis (2025 release wave 2)

> Business Central data analysis (analysis mode) in the 2025 release wave 2: Analysis Assist Copilot can add fields from related tables, server-side mode can pivot on date hierarchy, and right-click menu options were added. Flow fields cannot be calculated server-side.

[Watch on YouTube](https://www.youtube.com/watch?v=SHOAw9GehdI) · Microsoft Dynamics 365 Business Central (YouTube) · 2025-10-01 · 11:29 · tier official · reviewed (checked by Opus)

## Overview

The video covers three changes to data analysis, the ad hoc analysis tool on list pages and queries. It states that more than 70% of Business Central customers use it. Copilot support for natural language analysis was added a couple of releases earlier.

In the demo, Analysis Assist adds fields from tables related to the current analysis, such as a location name. Adding data from other tables, or analyzing large data sets or query objects, switches analysis to server-side loading, where data is retrieved on demand. In that mode, flow fields cannot be calculated. Pivoting on date hierarchy (year, quarter, month) now works in server-side mode. The video also shows right-click menu productivity improvements and points to learning and community resources.

## Key points

- Analysis Assist can now add fields from tables related to the current analysis, joining data across the data model, for example to bring in a location name.
- Users can do this manually with the 'add columns from' feature, which was added in the previous release and which Copilot now uses.
- Adding data from other tables, or analyzing large data sets or query objects, switches data analysis from client-side to server-side loading, and an info message shows this.
- In server-side mode, flow fields and other calculated fields cannot be used.
- Pivoting on date hierarchy (year, quarter, month) was not possible in server-side mode before this release and now is.
- The right-click menu offers add to labels, group or ungroup from row groups, and a scroll into view action to navigate fields.
- Data analysis is available on list pages and queries and lets users pivot and group data without building a report.

## Chapters

- [0:00](https://www.youtube.com/watch?v=SHOAw9GehdI&t=0s) Introduction to Data Analysis and Analysis Mode
- [1:27](https://www.youtube.com/watch?v=SHOAw9GehdI&t=87s) Copilot Demo - Adding Fields from Related Tables
- [3:31](https://www.youtube.com/watch?v=SHOAw9GehdI&t=211s) Server-Side Loading and Field Limitations
- [4:32](https://www.youtube.com/watch?v=SHOAw9GehdI&t=272s) Pivoting on Date Hierarchy in Server-Side Mode
- [5:40](https://www.youtube.com/watch?v=SHOAw9GehdI&t=340s) Productivity Improvements and Right-Click Menu
- [7:06](https://www.youtube.com/watch?v=SHOAw9GehdI&t=426s) Summary of Three New Features
- [7:54](https://www.youtube.com/watch?v=SHOAw9GehdI&t=474s) Learning Resources and Documentation
- [9:24](https://www.youtube.com/watch?v=SHOAw9GehdI&t=564s) Community Resources and Closing

## Features

Every feature below: status not stated, demoed.

| Feature | At |
|---|---|
| Analysis Assist Copilot | [0:38](https://www.youtube.com/watch?v=SHOAw9GehdI&t=38s) |
| Add Columns from Related Tables | [3:31](https://www.youtube.com/watch?v=SHOAw9GehdI&t=211s) |
| Server-Side Data Loading | [3:52](https://www.youtube.com/watch?v=SHOAw9GehdI&t=232s) |
| Pivot on Date Hierarchy in Server-Side Mode | [4:32](https://www.youtube.com/watch?v=SHOAw9GehdI&t=272s) |
| Right-Click Menu for Data Analysis | [5:40](https://www.youtube.com/watch?v=SHOAw9GehdI&t=340s) |
| Data Analysis Feature | [0:16](https://www.youtube.com/watch?v=SHOAw9GehdI&t=16s) |

## Quotes

- [0:16](https://www.youtube.com/watch?v=SHOAw9GehdI&t=16s) "more than 70% of all Business Central customers use data analysis, also known as analysis mode"
- [0:38](https://www.youtube.com/watch?v=SHOAw9GehdI&t=38s) "we even added a great co-pilot experience a couple of releases back so that you can also use natural language"
- [3:31](https://www.youtube.com/watch?v=SHOAw9GehdI&t=211s) "we have now ability for analysis assist to also add fields from tables that are related to what you're using here"
- [4:20](https://www.youtube.com/watch?v=SHOAw9GehdI&t=260s) "there are few things we you can't do such as flow fields things that are calculated"
- [4:32](https://www.youtube.com/watch?v=SHOAw9GehdI&t=272s) "One of the things you could not do in serverside mode until this release is pivoting on date hierarchy"
- [5:40](https://www.youtube.com/watch?v=SHOAw9GehdI&t=340s) "the third feature I wanted to show you is that we have some productivity improvements on the menu here"