---
id: video/qmLVKyHRhNc
type: video
title: "Introducing: Analyze Data on Lists and Queries (2023 release wave 2)"
summary: Analyze data on lists is generally available in Business Central 2023 release wave 2 (preview in wave 1). It offers no-code ad hoc analysis on live data and now also works on query objects. The 100,000 row limit is removed, and analysis definitions can be shared as links. Sample click-once scenarios are available, and a new Data analysis execute permission controls who can use it.
tier: official
language: en
tags:
  - data analysis
  - ad hoc reporting
  - analytics
  - list pages
  - query objects
  - no-code analysis
  - data visualization
  - pivoting data
  - grouping and filtering
  - query discoverability
  - analysis definitions
  - click-once
system: reporting
review:
  state: reviewed
  by: opus
  at: "2026-10-07T23:16:14.636Z"
  flags: []
generated:
  at: "2026-10-07T23:16:14.677Z"
  pipeline: 0.2.0
  prompts:
    extract-video: 1
    summarize-video: 2
  input_hash: 982903115e6cd9d7824b9aea32ab1f0fcd3e8227104980db03292720578562af
evidence:
  - kind: video
    url: https://www.youtube.com/watch?v=qmLVKyHRhNc&t=363s
    title: "Analyze data on list pages: generally available"
    date: "2023-10-23T05:29:46.000Z"
    commit: null
    t: 363
    quote: you needed to enable it under feature Management in this release wave this is generally available
  - kind: video
    url: https://www.youtube.com/watch?v=qmLVKyHRhNc&t=78s
    title: "Introducing: Analyze Data on Lists and Queries (2023 release wave 2)"
    date: "2023-10-23T05:29:46.000Z"
    commit: null
    t: 78
    quote: the word reporting in business Central means three different things analytical reports processing only reports and printable documents
  - kind: video
    url: https://www.youtube.com/watch?v=qmLVKyHRhNc&t=198s
    title: "Introducing: Analyze Data on Lists and Queries (2023 release wave 2)"
    date: "2023-10-23T05:29:46.000Z"
    commit: null
    t: 198
    quote: analytics is build for online consumption not for print
  - kind: video
    url: https://www.youtube.com/watch?v=qmLVKyHRhNc&t=239s
    title: "Introducing: Analyze Data on Lists and Queries (2023 release wave 2)"
    date: "2023-10-23T05:29:46.000Z"
    commit: null
    t: 239
    quote: business Central to have outof thee boox reporting and and analytics solutions for the Core Business scenarios
  - kind: video
    url: https://www.youtube.com/watch?v=qmLVKyHRhNc&t=363s
    title: "Introducing: Analyze Data on Lists and Queries (2023 release wave 2)"
    date: "2023-10-23T05:29:46.000Z"
    commit: null
    t: 363
    quote: this was in public preview in 2023 release wave one and you needed to enable it under feature Management in this release wave this
  - kind: video
    url: https://www.youtube.com/watch?v=qmLVKyHRhNc&t=472s
    title: "Introducing: Analyze Data on Lists and Queries (2023 release wave 2)"
    date: "2023-10-23T05:29:46.000Z"
    commit: null
    t: 472
    quote: with the with 23 2023 release Wave 2 we removed completely this limitation and you can allow you can analyze as much data as
  - kind: video
    url: https://www.youtube.com/watch?v=qmLVKyHRhNc&t=722s
    title: "Introducing: Analyze Data on Lists and Queries (2023 release wave 2)"
    date: "2023-10-23T05:29:46.000Z"
    commit: null
    t: 722
    quote: many users would actually see data analysis as reporting tool and they would call these my sales report
  - kind: video
    url: https://www.youtube.com/watch?v=qmLVKyHRhNc&t=742s
    title: "Introducing: Analyze Data on Lists and Queries (2023 release wave 2)"
    date: "2023-10-23T05:29:46.000Z"
    commit: null
    t: 742
    quote: it uh it's on live data no replicated data security model is preserved and uh totally no code analysis ad hoc analysis on your
  - kind: video
    url: https://www.youtube.com/watch?v=qmLVKyHRhNc&t=784s
    title: "Introducing: Analyze Data on Lists and Queries (2023 release wave 2)"
    date: "2023-10-23T05:29:46.000Z"
    commit: null
    t: 784
    quote: you can use a query object as the data foundation for this new way of doing ad hoc analysis or reporting
  - kind: video
    url: https://www.youtube.com/watch?v=qmLVKyHRhNc&t=797s
    title: "Introducing: Analyze Data on Lists and Queries (2023 release wave 2)"
    date: "2023-10-23T05:29:46.000Z"
    commit: null
    t: 797
    quote: the new thing is that this now comes with the same analysis chle and it opens the same UI now on queries
  - kind: video
    url: https://www.youtube.com/watch?v=qmLVKyHRhNc&t=971s
    title: "Introducing: Analyze Data on Lists and Queries (2023 release wave 2)"
    date: "2023-10-23T05:29:46.000Z"
    commit: null
    t: 971
    quote: queries are just any other UI element that will now show up in report or role Explorer and they are also searchable in tell
  - kind: video
    url: https://www.youtube.com/watch?v=qmLVKyHRhNc&t=1052s
    title: "Introducing: Analyze Data on Lists and Queries (2023 release wave 2)"
    date: "2023-10-23T05:29:46.000Z"
    commit: null
    t: 1052
    quote: build in analytical content for every use case or every main feature in business Central
  - kind: video
    url: https://www.youtube.com/watch?v=qmLVKyHRhNc&t=1172s
    title: "Introducing: Analyze Data on Lists and Queries (2023 release wave 2)"
    date: "2023-10-23T05:29:46.000Z"
    commit: null
    t: 1172
    quote: these only work in the in 2023 release Wave 2 uh but here are some different scenarios
  - kind: video
    url: https://www.youtube.com/watch?v=qmLVKyHRhNc&t=1347s
    title: "Introducing: Analyze Data on Lists and Queries (2023 release wave 2)"
    date: "2023-10-23T05:29:46.000Z"
    commit: null
    t: 1347
    quote: we added a new permission uh a new system permission called Data analysis exec or execute
  - kind: video
    url: https://www.youtube.com/watch?v=qmLVKyHRhNc&t=1568s
    title: "Introducing: Analyze Data on Lists and Queries (2023 release wave 2)"
    date: "2023-10-23T05:29:46.000Z"
    commit: null
    t: 1568
    quote: understand analytics requirements stop developing reports and start supporting analytical needs
  - kind: video
    url: https://www.youtube.com/watch?v=qmLVKyHRhNc&t=1579s
    title: "Introducing: Analyze Data on Lists and Queries (2023 release wave 2)"
    date: "2023-10-23T05:29:46.000Z"
    commit: null
    t: 1579
    quote: business intelligence and er they go together ER is about processing supporting business processes business's intelligence about insights on business processes
  - kind: video
    url: https://www.youtube.com/watch?v=qmLVKyHRhNc&t=1612s
    title: "Introducing: Analyze Data on Lists and Queries (2023 release wave 2)"
    date: "2023-10-23T05:29:46.000Z"
    commit: null
    t: 1612
    quote: if you thought Al queries was just about performance tuning it's not anymore we're changing the game for this we're investing more in queries
  - kind: video
    url: https://www.youtube.com/watch?v=qmLVKyHRhNc&t=1612s
    title: "Introducing: Analyze Data on Lists and Queries (2023 release wave 2)"
    date: "2023-10-23T05:29:46.000Z"
    commit: null
    t: 1612
    quote: we're changing the game for this we're investing more in queries over the next years
  - kind: video
    url: https://www.youtube.com/watch?v=qmLVKyHRhNc&t=1632s
    title: "Introducing: Analyze Data on Lists and Queries (2023 release wave 2)"
    date: "2023-10-23T05:29:46.000Z"
    commit: null
    t: 1632
    quote: instead of buil me a report it's it's going to be buil me a report data set
  - kind: video
    url: https://www.youtube.com/watch?v=qmLVKyHRhNc&t=1673s
    title: "Introducing: Analyze Data on Lists and Queries (2023 release wave 2)"
    date: "2023-10-23T05:29:46.000Z"
    commit: null
    t: 1673
    quote: adding existing uh table fields to optimize PES is is also a way to do ad hog analysis
links:
  learn: []
  objects: []
  features: []
  topics: []
  localizations: []
  videos: []
  posts: []
  guidelines: []
video_id: qmLVKyHRhNc
channel: yt-microsoft
source_name: Microsoft Dynamics 365 Business Central (YouTube)
url: https://www.youtube.com/watch?v=qmLVKyHRhNc
published_at: "2023-10-23T05:29:46.000Z"
duration_s: 1747
captions: full
audience:
  - functional consultant
  - developer
  - administrator
  - end user
chapters:
  - t: 0
    title: Introduction and agenda overview
  - t: 61
    title: "Context: changing world of analytics and reporting"
  - t: 198
    title: Vision for analytics and reporting in Business Central
  - t: 291
    title: "Feature overview: analyze data on lists and queries"
  - t: 493
    title: "Demo: analyzing data on customer ledger entries"
  - t: 763
    title: Query objects and inventory analysis demo
  - t: 960
    title: Query discoverability and role explorer
  - t: 1012
    title: Analytical content vision for business central
  - t: 1069
    title: Sharing analysis definitions with coworkers
  - t: 1142
    title: Click-once installers and data analysis persistence
  - t: 1326
    title: Data analysis permission control
  - t: 1387
    title: Sample scenarios and resources
  - t: 1444
    title: Analytical requirements, reporting strategy, and AL queries
  - t: 1653
    title: Additional resources and learning paths
  - t: 1693
    title: Community engagement and closing remarks
features:
  - name: Analyze data on list pages
    status: ga
    t: 291
    verified: true
    status_source: video
  - name: Analysis menu persistence
    status: unclear
    t: 414
    verified: false
    status_source: video
  - name: Remove data size limitation
    status: unclear
    t: 451
    verified: false
    status_source: video
  - name: Analyze data on query objects
    status: unclear
    t: 763
    verified: false
    status_source: video
  - name: Query documentation with teaching tips and links
    status: unclear
    t: 850
    verified: false
    status_source: video
  - name: Join related table data in queries
    status: unclear
    t: 871
    verified: false
    status_source: video
  - name: Queries in report and role explorer
    status: unclear
    t: 971
    verified: false
    status_source: video
  - name: Report and role explorer for content discoverability
    status: unclear
    t: 1012
    verified: false
    status_source: video
  - name: Built-in analytical content vision
    status: unclear
    t: 1052
    verified: false
    status_source: video
  - name: Share analysis definitions with coworkers
    status: unclear
    t: 1069
    verified: false
    status_source: video
  - name: Company-specific and company-agnostic analysis links
    status: unclear
    t: 1121
    verified: false
    status_source: video
  - name: Click-once installers for analysis
    status: unclear
    t: 1142
    verified: false
    status_source: video
  - name: Data analysis execute permission
    status: unclear
    t: 1326
    verified: false
    status_source: video
  - name: Sample click-once scenarios repository
    status: unclear
    t: 1387
    verified: false
    status_source: video
  - name: AL Queries for analytics
    status: unclear
    t: 1612
    verified: false
    status_source: video
  - name: Data sets for Excel layouts
    status: unclear
    t: 1632
    verified: false
    status_source: video
objects_mentioned:
  - table Customer Ledger entries
  - query analyze your invent inventory
quotes:
  - t: 78
    text: the word reporting in business Central means three different things analytical reports processing only reports and printable documents
    check: exact
  - t: 198
    text: analytics is build for online consumption not for print
    check: exact
  - t: 239
    text: business Central to have outof thee boox reporting and and analytics solutions for the Core Business scenarios
    check: exact
  - t: 363
    text: this was in public preview in 2023 release wave one and you needed to enable it under feature Management in this release wave this
    check: exact
  - t: 472
    text: with the with 23 2023 release Wave 2 we removed completely this limitation and you can allow you can analyze as much data as
    check: snapped
  - t: 722
    text: many users would actually see data analysis as reporting tool and they would call these my sales report
    check: snapped
  - t: 742
    text: it uh it's on live data no replicated data security model is preserved and uh totally no code analysis ad hoc analysis on your
    check: snapped
  - t: 784
    text: you can use a query object as the data foundation for this new way of doing ad hoc analysis or reporting
    check: exact
  - t: 797
    text: the new thing is that this now comes with the same analysis chle and it opens the same UI now on queries
    check: exact
  - t: 971
    text: queries are just any other UI element that will now show up in report or role Explorer and they are also searchable in tell
    check: exact
  - t: 1052
    text: build in analytical content for every use case or every main feature in business Central
    check: exact
  - t: 1172
    text: these only work in the in 2023 release Wave 2 uh but here are some different scenarios
    check: exact
  - t: 1347
    text: we added a new permission uh a new system permission called Data analysis exec or execute
    check: exact
  - t: 1568
    text: understand analytics requirements stop developing reports and start supporting analytical needs
    check: exact
  - t: 1579
    text: business intelligence and er they go together ER is about processing supporting business processes business's intelligence about insights on business processes
    check: exact
  - t: 1612
    text: if you thought Al queries was just about performance tuning it's not anymore we're changing the game for this we're investing more in queries
    check: exact
  - t: 1612
    text: we're changing the game for this we're investing more in queries over the next years
    check: fuzzy
  - t: 1632
    text: instead of buil me a report it's it's going to be buil me a report data set
    check: exact
  - t: 1673
    text: adding existing uh table fields to optimize PES is is also a way to do ad hog analysis
    check: exact
---

# Introducing: Analyze Data on Lists and Queries (2023 release wave 2)

> Analyze data on lists is generally available in Business Central 2023 release wave 2 (preview in wave 1). It offers no-code ad hoc analysis on live data and now also works on query objects. The 100,000 row limit is removed, and analysis definitions can be shared as links. Sample click-once scenarios are available, and a new Data analysis execute permission controls who can use it.

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

## Overview

The session places data analysis within Microsoft's vision for analytics and reporting in Business Central. It separates analytical reports, processing-only reports and printable documents, and says analytics is built for online consumption. It demos analysis on customer ledger entries and on an inventory query that joins related tables.

It then covers query discoverability in Tell Me and the role and report explorers, sharing analysis definitions through links, click-once sample scenarios, and the permission that controls analysis. It closes with guidance for developers: build queries and data sets for analytical needs rather than building more reports.

## Key points

- Analyze data mode on list pages was in public preview in 2023 release wave 1 and had to be turned on in Feature Management. In 2023 release wave 2 it is generally available and on for all users.
- The 100,000 row limit on analyze data mode is removed in 2023 release wave 2. Large datasets may load more slowly.
- Query objects can be the data foundation for analysis and open the same analysis UI as lists. Joining related tables lets you show location names instead of codes.
- Analysis definitions can be shared by link, for one company or for all companies. The recipient gets an independent copy, not a live link.
- A new system permission, Data analysis execute, controls who can analyze. A developer can also turn the feature off.
- Click-once sample scenarios (15, covering finance, sales, inventory and compliance) are at aka.ms/bc data analysis and work only in 2023 release wave 2.
- Query discoverability in Tell Me and the role and report explorers came late in the release and is likely available in version 23.1.

## Chapters

- [0:00](https://www.youtube.com/watch?v=qmLVKyHRhNc&t=0s) Introduction and agenda overview
- [1:01](https://www.youtube.com/watch?v=qmLVKyHRhNc&t=61s) Context: changing world of analytics and reporting
- [3:18](https://www.youtube.com/watch?v=qmLVKyHRhNc&t=198s) Vision for analytics and reporting in Business Central
- [4:51](https://www.youtube.com/watch?v=qmLVKyHRhNc&t=291s) Feature overview: analyze data on lists and queries
- [8:13](https://www.youtube.com/watch?v=qmLVKyHRhNc&t=493s) Demo: analyzing data on customer ledger entries
- [12:43](https://www.youtube.com/watch?v=qmLVKyHRhNc&t=763s) Query objects and inventory analysis demo
- [16:00](https://www.youtube.com/watch?v=qmLVKyHRhNc&t=960s) Query discoverability and role explorer
- [16:52](https://www.youtube.com/watch?v=qmLVKyHRhNc&t=1012s) Analytical content vision for business central
- [17:49](https://www.youtube.com/watch?v=qmLVKyHRhNc&t=1069s) Sharing analysis definitions with coworkers
- [19:02](https://www.youtube.com/watch?v=qmLVKyHRhNc&t=1142s) Click-once installers and data analysis persistence
- [22:06](https://www.youtube.com/watch?v=qmLVKyHRhNc&t=1326s) Data analysis permission control
- [23:07](https://www.youtube.com/watch?v=qmLVKyHRhNc&t=1387s) Sample scenarios and resources
- [24:04](https://www.youtube.com/watch?v=qmLVKyHRhNc&t=1444s) Analytical requirements, reporting strategy, and AL queries
- [27:33](https://www.youtube.com/watch?v=qmLVKyHRhNc&t=1653s) Additional resources and learning paths
- [28:13](https://www.youtube.com/watch?v=qmLVKyHRhNc&t=1693s) Community engagement and closing remarks

## Features

| Feature | Status | At | Evidence |
|---|---|---|---|
| Analyze data on list pages | generally available, demoed | [4:51](https://www.youtube.com/watch?v=qmLVKyHRhNc&t=291s) | "you needed to enable it under feature Management in this release wave this is generally available" ([6:03](https://www.youtube.com/watch?v=qmLVKyHRhNc&t=363s)) |
| Analysis menu persistence | status not stated, demoed | [6:54](https://www.youtube.com/watch?v=qmLVKyHRhNc&t=414s) |  |
| Remove data size limitation | status not stated | [7:31](https://www.youtube.com/watch?v=qmLVKyHRhNc&t=451s) |  |
| Analyze data on query objects | status not stated, demoed | [12:43](https://www.youtube.com/watch?v=qmLVKyHRhNc&t=763s) |  |
| Query documentation with teaching tips and links | status not stated, demoed | [14:10](https://www.youtube.com/watch?v=qmLVKyHRhNc&t=850s) |  |
| Join related table data in queries | status not stated, demoed | [14:31](https://www.youtube.com/watch?v=qmLVKyHRhNc&t=871s) |  |
| Queries in report and role explorer | status not stated | [16:11](https://www.youtube.com/watch?v=qmLVKyHRhNc&t=971s) |  |
| Report and role explorer for content discoverability | status not stated | [16:52](https://www.youtube.com/watch?v=qmLVKyHRhNc&t=1012s) |  |
| Built-in analytical content vision | status not stated | [17:32](https://www.youtube.com/watch?v=qmLVKyHRhNc&t=1052s) |  |
| Share analysis definitions with coworkers | status not stated, demoed | [17:49](https://www.youtube.com/watch?v=qmLVKyHRhNc&t=1069s) |  |
| Company-specific and company-agnostic analysis links | status not stated, demoed | [18:41](https://www.youtube.com/watch?v=qmLVKyHRhNc&t=1121s) |  |
| Click-once installers for analysis | status not stated, demoed | [19:02](https://www.youtube.com/watch?v=qmLVKyHRhNc&t=1142s) |  |
| Data analysis execute permission | status not stated | [22:06](https://www.youtube.com/watch?v=qmLVKyHRhNc&t=1326s) |  |
| Sample click-once scenarios repository | status not stated, demoed | [23:07](https://www.youtube.com/watch?v=qmLVKyHRhNc&t=1387s) |  |
| AL Queries for analytics | status not stated | [26:52](https://www.youtube.com/watch?v=qmLVKyHRhNc&t=1612s) |  |
| Data sets for Excel layouts | status not stated | [27:12](https://www.youtube.com/watch?v=qmLVKyHRhNc&t=1632s) |  |

## 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.

- table "Customer Ledger entries" at [8:33](https://www.youtube.com/watch?v=qmLVKyHRhNc&t=513s)
- query "analyze your invent inventory" at [14:10](https://www.youtube.com/watch?v=qmLVKyHRhNc&t=850s)

Not found in BC28-30: table "Customer Ledger entries", query "analyze your invent inventory".

## Quotes

- [1:18](https://www.youtube.com/watch?v=qmLVKyHRhNc&t=78s) "the word reporting in business Central means three different things analytical reports processing only reports and printable documents"
- [3:18](https://www.youtube.com/watch?v=qmLVKyHRhNc&t=198s) "analytics is build for online consumption not for print"
- [3:59](https://www.youtube.com/watch?v=qmLVKyHRhNc&t=239s) "business Central to have outof thee boox reporting and and analytics solutions for the Core Business scenarios"
- [6:03](https://www.youtube.com/watch?v=qmLVKyHRhNc&t=363s) "this was in public preview in 2023 release wave one and you needed to enable it under feature Management in this release wave this"
- [7:52](https://www.youtube.com/watch?v=qmLVKyHRhNc&t=472s) "with the with 23 2023 release Wave 2 we removed completely this limitation and you can allow you can analyze as much data as"
- [12:02](https://www.youtube.com/watch?v=qmLVKyHRhNc&t=722s) "many users would actually see data analysis as reporting tool and they would call these my sales report"
- [12:22](https://www.youtube.com/watch?v=qmLVKyHRhNc&t=742s) "it uh it's on live data no replicated data security model is preserved and uh totally no code analysis ad hoc analysis on your"
- [13:04](https://www.youtube.com/watch?v=qmLVKyHRhNc&t=784s) "you can use a query object as the data foundation for this new way of doing ad hoc analysis or reporting"
- [13:17](https://www.youtube.com/watch?v=qmLVKyHRhNc&t=797s) "the new thing is that this now comes with the same analysis chle and it opens the same UI now on queries"
- [16:11](https://www.youtube.com/watch?v=qmLVKyHRhNc&t=971s) "queries are just any other UI element that will now show up in report or role Explorer and they are also searchable in tell"
- [17:32](https://www.youtube.com/watch?v=qmLVKyHRhNc&t=1052s) "build in analytical content for every use case or every main feature in business Central"
- [19:32](https://www.youtube.com/watch?v=qmLVKyHRhNc&t=1172s) "these only work in the in 2023 release Wave 2 uh but here are some different scenarios"
- [22:27](https://www.youtube.com/watch?v=qmLVKyHRhNc&t=1347s) "we added a new permission uh a new system permission called Data analysis exec or execute"
- [26:08](https://www.youtube.com/watch?v=qmLVKyHRhNc&t=1568s) "understand analytics requirements stop developing reports and start supporting analytical needs"
- [26:19](https://www.youtube.com/watch?v=qmLVKyHRhNc&t=1579s) "business intelligence and er they go together ER is about processing supporting business processes business's intelligence about insights on business processes"
- [26:52](https://www.youtube.com/watch?v=qmLVKyHRhNc&t=1612s) "if you thought Al queries was just about performance tuning it's not anymore we're changing the game for this we're investing more in queries"
- [26:52](https://www.youtube.com/watch?v=qmLVKyHRhNc&t=1612s) "we're changing the game for this we're investing more in queries over the next years"
- [27:12](https://www.youtube.com/watch?v=qmLVKyHRhNc&t=1632s) "instead of buil me a report it's it's going to be buil me a report data set"
- [27:53](https://www.youtube.com/watch?v=qmLVKyHRhNc&t=1673s) "adding existing uh table fields to optimize PES is is also a way to do ad hog analysis"

## Disclaimers in the video

- [6:03](https://www.youtube.com/watch?v=qmLVKyHRhNc&t=363s) preview: this was in public preview in 2023 release wave one
- [16:00](https://www.youtube.com/watch?v=qmLVKyHRhNc&t=960s) coming-later: a few features came in a bit late in our release so they are likely available in version 23.1
- [19:32](https://www.youtube.com/watch?v=qmLVKyHRhNc&t=1172s) subject-to-change: these only work in the in 2023 release Wave 2