---
id: video/c3paEbmDNmM
type: video
title: "What's New: Server and Database - New Reporting Capabilities (2023 release wave 2)"
summary: "New reporting capabilities in Business Central 2023 release wave 2: data analysis on query objects, Excel layouts with multiple data sheets for parent-child data, Power Query and Power Pivot in Excel layouts, and teaching tips and help links for reports and queries. Data analysis on lists and queries is stated as generally available."
tier: official
language: en
tags:
  - queries
  - analysis views
  - excel layouts
  - power query
  - power pivot
  - teaching tips
  - help links
  - report design
  - data analysis
  - kpis
system: reporting
review:
  state: reviewed
  by: opus
  at: "2026-10-07T23:13:41.161Z"
  flags: []
generated:
  at: "2026-10-07T23:13:41.200Z"
  pipeline: 0.2.0
  prompts:
    extract-video: 1
    summarize-video: 2
  input_hash: 24e06184a217d1e144bc17c77fc4e8f934eaacb0849437df3f16e8da3e3a12f0
evidence:
  - kind: video
    url: https://www.youtube.com/watch?v=c3paEbmDNmM&t=672s
    title: "Data Analysis on Queries: generally available"
    date: "2023-12-18T08:57:57.000Z"
    commit: null
    t: 672
    quote: this data analysis this feature that is now generally available on lists and queries
  - kind: video
    url: https://www.youtube.com/watch?v=c3paEbmDNmM&t=18s
    title: "What's New: Server and Database - New Reporting Capabilities (2023 release wave 2)"
    date: "2023-12-18T08:57:57.000Z"
    commit: null
    t: 18
    quote: yes the query object has been there for 10 years and it's time that it gets a bit more prominence so now you've always
  - kind: video
    url: https://www.youtube.com/watch?v=c3paEbmDNmM&t=119s
    title: "What's New: Server and Database - New Reporting Capabilities (2023 release wave 2)"
    date: "2023-12-18T08:57:57.000Z"
    commit: null
    t: 119
    quote: the ability to handle large amounts of data the way we do these queries is that each drill down is a query by itself
  - kind: video
    url: https://www.youtube.com/watch?v=c3paEbmDNmM&t=308s
    title: "What's New: Server and Database - New Reporting Capabilities (2023 release wave 2)"
    date: "2023-12-18T08:57:57.000Z"
    commit: null
    t: 308
    quote: Excel layout multiple data sheets available in version 23 if you set it to true you get these new multiple data sheets in your
  - kind: video
    url: https://www.youtube.com/watch?v=c3paEbmDNmM&t=499s
    title: "What's New: Server and Database - New Reporting Capabilities (2023 release wave 2)"
    date: "2023-12-18T08:57:57.000Z"
    commit: null
    t: 499
    quote: you need to to stop just developing reports and instead understand what is the user trying to do with analytics and based on that
  - kind: video
    url: https://www.youtube.com/watch?v=c3paEbmDNmM&t=560s
    title: "What's New: Server and Database - New Reporting Capabilities (2023 release wave 2)"
    date: "2023-12-18T08:57:57.000Z"
    commit: null
    t: 560
    quote: powerbi is here to stay and it's going to be the tool of choice especially for for for kpis on business Central
  - kind: video
    url: https://www.youtube.com/watch?v=c3paEbmDNmM&t=580s
    title: "What's New: Server and Database - New Reporting Capabilities (2023 release wave 2)"
    date: "2023-12-18T08:57:57.000Z"
    commit: null
    t: 580
    quote: they are very powerful to actually join data together from multiple sources and allow the user to the freedom to slice and dice as
  - kind: video
    url: https://www.youtube.com/watch?v=c3paEbmDNmM&t=600s
    title: "What's New: Server and Database - New Reporting Capabilities (2023 release wave 2)"
    date: "2023-12-18T08:57:57.000Z"
    commit: null
    t: 600
    quote: very often just having a good report data set and a good first layout allows the customer to add what they need in the
links:
  learn: []
  objects: []
  features: []
  topics: []
  localizations: []
  videos: []
  posts: []
  guidelines: []
video_id: c3paEbmDNmM
channel: yt-microsoft
source_name: Microsoft Dynamics 365 Business Central (YouTube)
url: https://www.youtube.com/watch?v=c3paEbmDNmM
published_at: "2023-12-18T08:57:57.000Z"
duration_s: 723
captions: full
audience:
  - developer
  - functional consultant
  - administrator
chapters:
  - t: 0
    title: Data Analysis on Queries
  - t: 140
    title: Excel Layouts for Parent-Child Relationships
  - t: 230
    title: Excel Power Query and Power Pivot Integration
  - t: 330
    title: Teaching Tips and Help Links for Reports and Queries
  - t: 440
    title: Reports Documentation and Resources
  - t: 500
    title: Analytics Strategy and Query Design Approach
  - t: 660
    title: Relevant Sessions and Closing
features:
  - name: Data Analysis on Queries
    status: ga
    t: 18
    verified: true
    status_source: video
  - name: Server-Side Analysis Views on Queries
    status: unclear
    t: 99
    verified: false
    status_source: video
  - name: Excel Layout Multiple Data Sheets
    status: unclear
    t: 159
    verified: false
    status_source: video
  - name: Excel Power Query and Power Pivot Support
    status: unclear
    t: 232
    verified: false
    status_source: video
  - name: Teaching Tips on Reports and Queries
    status: unclear
    t: 346
    verified: false
    status_source: video
  - name: Help Links for Reports and Queries
    status: unclear
    t: 346
    verified: false
    status_source: video
objects_mentioned:
  - query item hero query
  - query analyze inventory query
quotes:
  - t: 18
    text: yes the query object has been there for 10 years and it's time that it gets a bit more prominence so now you've always
    check: snapped
  - t: 119
    text: the ability to handle large amounts of data the way we do these queries is that each drill down is a query by itself
    check: exact
  - t: 308
    text: Excel layout multiple data sheets available in version 23 if you set it to true you get these new multiple data sheets in your
    check: exact
  - t: 499
    text: you need to to stop just developing reports and instead understand what is the user trying to do with analytics and based on that
    check: snapped
  - t: 560
    text: powerbi is here to stay and it's going to be the tool of choice especially for for for kpis on business Central
    check: exact
  - t: 580
    text: they are very powerful to actually join data together from multiple sources and allow the user to the freedom to slice and dice as
    check: exact
  - t: 600
    text: very often just having a good report data set and a good first layout allows the customer to add what they need in the
    check: exact
---

# What's New: Server and Database - New Reporting Capabilities (2023 release wave 2)

> New reporting capabilities in Business Central 2023 release wave 2: data analysis on query objects, Excel layouts with multiple data sheets for parent-child data, Power Query and Power Pivot in Excel layouts, and teaching tips and help links for reports and queries. Data analysis on lists and queries is stated as generally available.

[Watch on YouTube](https://www.youtube.com/watch?v=c3paEbmDNmM) · Microsoft Dynamics 365 Business Central (YouTube) · 2023-12-18 · 12:03 · tier official · reviewed (checked by Opus)

## Overview

The session covers server and database reporting changes in the 2023 release wave 2. The query object now has an analysis view attached and can be opened from the UI with Run object, for example as an action on a page, with grouping and pivoting. Drill-downs run as separate queries at the server level, so large record counts can be summed and explored.

For Excel layouts, parent-child (overview-detail) data can be generated as multiple root data items in separate sheets instead of one flat data set. Power Query and Power Pivot can be used to transform data and model relationships. The video also shows teaching tips and help links on report and query request pages, and ends with advice to design around what the user is trying to do with analytics, with Power BI named as the tool of choice for KPIs.

## Key points

- Query objects now have an analysis view and can be run from the UI with Run object, for example as an action on a page, with grouping and pivoting.
- Server-side drill-down: each drill-down is a query by itself, which lets users sum millions of records and drill into them.
- Excel layout multiple data sheets is available in version 23. You enable it with a property, and it applies only to reports that target the Excel layout type.
- Excel layouts support Power Query and Power Pivot, but users may need to learn Excel modeling techniques.
- Teaching tips appear on report and query request pages. They can be dismissed and recalled by hovering over the title.
- Developers can create help links for reports and queries that show on request pages and in the help pane.
- Design guidance: understand what the user is trying to do with analytics, and a good report data set with a good first layout often lets customers add what they need.

## Chapters

- [0:00](https://www.youtube.com/watch?v=c3paEbmDNmM&t=0s) Data Analysis on Queries
- [2:20](https://www.youtube.com/watch?v=c3paEbmDNmM&t=140s) Excel Layouts for Parent-Child Relationships
- [3:50](https://www.youtube.com/watch?v=c3paEbmDNmM&t=230s) Excel Power Query and Power Pivot Integration
- [5:30](https://www.youtube.com/watch?v=c3paEbmDNmM&t=330s) Teaching Tips and Help Links for Reports and Queries
- [7:20](https://www.youtube.com/watch?v=c3paEbmDNmM&t=440s) Reports Documentation and Resources
- [8:20](https://www.youtube.com/watch?v=c3paEbmDNmM&t=500s) Analytics Strategy and Query Design Approach
- [11:00](https://www.youtube.com/watch?v=c3paEbmDNmM&t=660s) Relevant Sessions and Closing

## Features

| Feature | Status | At | Evidence |
|---|---|---|---|
| Data Analysis on Queries | generally available, demoed | [0:18](https://www.youtube.com/watch?v=c3paEbmDNmM&t=18s) | "this data analysis this feature that is now generally available on lists and queries" ([11:12](https://www.youtube.com/watch?v=c3paEbmDNmM&t=672s)) |
| Server-Side Analysis Views on Queries | status not stated | [1:39](https://www.youtube.com/watch?v=c3paEbmDNmM&t=99s) |  |
| Excel Layout Multiple Data Sheets | status not stated, demoed | [2:39](https://www.youtube.com/watch?v=c3paEbmDNmM&t=159s) |  |
| Excel Power Query and Power Pivot Support | status not stated, demoed | [3:52](https://www.youtube.com/watch?v=c3paEbmDNmM&t=232s) |  |
| Teaching Tips on Reports and Queries | status not stated, demoed | [5:46](https://www.youtube.com/watch?v=c3paEbmDNmM&t=346s) |  |
| Help Links for Reports and Queries | status not stated, demoed | [5:46](https://www.youtube.com/watch?v=c3paEbmDNmM&t=346s) |  |

## AL objects mentioned

As heard in the captions. A name that matches one object page by exact type and name links to it; the others stay as named.

- query "item hero query" at [0:58](https://www.youtube.com/watch?v=c3paEbmDNmM&t=58s)
- query "analyze inventory query" at [6:47](https://www.youtube.com/watch?v=c3paEbmDNmM&t=407s)

Not found in BC28-30: query "item hero query", query "analyze inventory query".

## Quotes

- [0:18](https://www.youtube.com/watch?v=c3paEbmDNmM&t=18s) "yes the query object has been there for 10 years and it's time that it gets a bit more prominence so now you've always"
- [1:59](https://www.youtube.com/watch?v=c3paEbmDNmM&t=119s) "the ability to handle large amounts of data the way we do these queries is that each drill down is a query by itself"
- [5:08](https://www.youtube.com/watch?v=c3paEbmDNmM&t=308s) "Excel layout multiple data sheets available in version 23 if you set it to true you get these new multiple data sheets in your"
- [8:19](https://www.youtube.com/watch?v=c3paEbmDNmM&t=499s) "you need to to stop just developing reports and instead understand what is the user trying to do with analytics and based on that"
- [9:20](https://www.youtube.com/watch?v=c3paEbmDNmM&t=560s) "powerbi is here to stay and it's going to be the tool of choice especially for for for kpis on business Central"
- [9:40](https://www.youtube.com/watch?v=c3paEbmDNmM&t=580s) "they are very powerful to actually join data together from multiple sources and allow the user to the freedom to slice and dice as"
- [10:00](https://www.youtube.com/watch?v=c3paEbmDNmM&t=600s) "very often just having a good report data set and a good first layout allows the customer to add what they need in the"

## Disclaimers in the video

- [2:19](https://www.youtube.com/watch?v=c3paEbmDNmM&t=139s) other: this is not the session you're thinking of so for Excel layouts um the Excel layouts feature did not really handle parent child overview detail types very well
- [7:21](https://www.youtube.com/watch?v=c3paEbmDNmM&t=441s) other: something we're working on right now so that should hopefully be in the doc over the next month