--- id: video/mHrY_OI0qNo type: video title: "Introducing: AI-Powered Analysis with Copilot (2024 release wave 1)" summary: Analysis Assist with Copilot in Business Central, in public preview with 2024 release wave 1 (version 24.0 or later). Users describe an analysis in natural language and Copilot builds columns, filters, sorting and grouping on list pages. Covers limits, availability, data privacy and admin requirements. tier: official language: en tags: - ai-powered analysis - copilot - analysis assist - natural language - ad hoc analytics - pivot tables - data insights - list analysis - filtering - grouping - responsible ai - preview capability system: copilot review: state: reviewed by: opus at: "2026-10-07T23:08:44.703Z" flags: [] generated: at: "2026-10-07T23:08:44.761Z" pipeline: 0.2.0 prompts: extract-video: 1 summarize-video: 2 input_hash: 785f08a04ea094b70049cdf1e7cc1a42384bf8072541a68e6f014280dab8b31a evidence: - kind: video url: https://www.youtube.com/watch?v=mHrY_OI0qNo&t=139s title: "Analysis Assist: preview" date: "2024-04-04T13:30:31.000Z" commit: null t: 139 quote: that's why we're excited to announce the public preview of analysis assist - kind: video url: https://www.youtube.com/watch?v=mHrY_OI0qNo&t=901s title: "Analyze List Action: preview" date: "2024-04-04T13:30:31.000Z" commit: null t: 901 quote: co-pilot at this stage in preview will only work with fields that are shown on the page - kind: video url: https://www.youtube.com/watch?v=mHrY_OI0qNo&t=901s title: "Draft Tab Management: preview" date: "2024-04-04T13:30:31.000Z" commit: null t: 901 quote: co-pilot at this stage in preview will only work with fields that are shown on the page - kind: video url: https://www.youtube.com/watch?v=mHrY_OI0qNo&t=901s title: "Semantic Understanding for Filters: preview" date: "2024-04-04T13:30:31.000Z" commit: null t: 901 quote: co-pilot at this stage in preview will only work with fields that are shown on the page - kind: video url: https://www.youtube.com/watch?v=mHrY_OI0qNo&t=901s title: "Prompt Guide: preview" date: "2024-04-04T13:30:31.000Z" commit: null t: 901 quote: co-pilot at this stage in preview will only work with fields that are shown on the page - kind: video url: https://www.youtube.com/watch?v=mHrY_OI0qNo&t=901s title: "Grouping and Pivoting: preview" date: "2024-04-04T13:30:31.000Z" commit: null t: 901 quote: co-pilot at this stage in preview will only work with fields that are shown on the page - kind: video url: https://www.youtube.com/watch?v=mHrY_OI0qNo&t=982s title: "Copilot availability and deployment: preview" date: "2024-04-04T13:30:31.000Z" commit: null t: 982 quote: it's also available in preview in English language only so you'll need to make sure - kind: video url: https://www.youtube.com/watch?v=mHrY_OI0qNo&t=139s title: "Introducing: AI-Powered Analysis with Copilot (2024 release wave 1)" date: "2024-04-04T13:30:31.000Z" commit: null t: 139 quote: that's why we're excited to announce the public preview of analysis assist - kind: video url: https://www.youtube.com/watch?v=mHrY_OI0qNo&t=159s title: "Introducing: AI-Powered Analysis with Copilot (2024 release wave 1)" date: "2024-04-04T13:30:31.000Z" commit: null t: 159 quote: with this new capability helps uh reduce the time it takes to get to identifying Trends uh anomalies in your business data uh simply - kind: video url: https://www.youtube.com/watch?v=mHrY_OI0qNo&t=179s title: "Introducing: AI-Powered Analysis with Copilot (2024 release wave 1)" date: "2024-04-04T13:30:31.000Z" commit: null t: 179 quote: by describing in a simple sentence how you want to structure your data uh you quickly get to insights instead of spending the time - kind: video url: https://www.youtube.com/watch?v=mHrY_OI0qNo&t=199s title: "Introducing: AI-Powered Analysis with Copilot (2024 release wave 1)" date: "2024-04-04T13:30:31.000Z" commit: null t: 199 quote: more people across the organization can uh make datadriven decisions themselves - kind: video url: https://www.youtube.com/watch?v=mHrY_OI0qNo&t=652s title: "Introducing: AI-Powered Analysis with Copilot (2024 release wave 1)" date: "2024-04-04T13:30:31.000Z" commit: null t: 652 quote: we don't send any of your data to co-pilot because that's not what's needed the only thing we actually send to co-pilot is the - kind: video url: https://www.youtube.com/watch?v=mHrY_OI0qNo&t=722s title: "Introducing: AI-Powered Analysis with Copilot (2024 release wave 1)" date: "2024-04-04T13:30:31.000Z" commit: null t: 722 quote: we just in a natural language sentence told copile what we wanted and uh now it comes back wow with an analysis with the - kind: video url: https://www.youtube.com/watch?v=mHrY_OI0qNo&t=861s title: "Introducing: AI-Powered Analysis with Copilot (2024 release wave 1)" date: "2024-04-04T13:30:31.000Z" commit: null t: 861 quote: I kind of like the idea that co-pilot helped me get started with my analysis but in the end I was in control - kind: video url: https://www.youtube.com/watch?v=mHrY_OI0qNo&t=901s title: "Introducing: AI-Powered Analysis with Copilot (2024 release wave 1)" date: "2024-04-04T13:30:31.000Z" commit: null t: 901 quote: co-pilot at this stage in preview will only work with fields that are shown on the page on the list page itself - kind: video url: https://www.youtube.com/watch?v=mHrY_OI0qNo&t=921s title: "Introducing: AI-Powered Analysis with Copilot (2024 release wave 1)" date: "2024-04-04T13:30:31.000Z" commit: null t: 921 quote: co-pilot here and the ability to analyze that list is available on all virtually all list pages and I believe worksheets as well in - kind: video url: https://www.youtube.com/watch?v=mHrY_OI0qNo&t=982s title: "Introducing: AI-Powered Analysis with Copilot (2024 release wave 1)" date: "2024-04-04T13:30:31.000Z" commit: null t: 982 quote: this has been released with 2024 release Wave 1 so you'll need to upgrade to version 24.0 or later - kind: video url: https://www.youtube.com/watch?v=mHrY_OI0qNo&t=1002s title: "Introducing: AI-Powered Analysis with Copilot (2024 release wave 1)" date: "2024-04-04T13:30:31.000Z" commit: null t: 1002 quote: at this stage co-pilot is available uh with your business Central license at no additional cost - kind: video url: https://www.youtube.com/watch?v=mHrY_OI0qNo&t=1020s title: "Introducing: AI-Powered Analysis with Copilot (2024 release wave 1)" date: "2024-04-04T13:30:31.000Z" commit: null t: 1020 quote: our promise to our customers is that their data is their data we do not use that data to train the AI models - kind: video url: https://www.youtube.com/watch?v=mHrY_OI0qNo&t=1081s title: "Introducing: AI-Powered Analysis with Copilot (2024 release wave 1)" date: "2024-04-04T13:30:31.000Z" commit: null t: 1081 quote: ai is sometimes incorrect and that's why we always give our users the opportunity to review what co pilot has generated before - kind: video url: https://www.youtube.com/watch?v=mHrY_OI0qNo&t=1173s title: "Introducing: AI-Powered Analysis with Copilot (2024 release wave 1)" date: "2024-04-04T13:30:31.000Z" commit: null t: 1173 quote: because Azure open AI service is only available in uh certain regions but not all some of our customers on some environments will need links: learn: [] objects: - object/table/27 features: [] topics: [] localizations: [] videos: [] posts: [] guidelines: [] video_id: mHrY_OI0qNo channel: yt-microsoft source_name: Microsoft Dynamics 365 Business Central (YouTube) url: https://www.youtube.com/watch?v=mHrY_OI0qNo published_at: "2024-04-04T13:30:31.000Z" duration_s: 1387 captions: full audience: - functional consultant - administrator - end user - decision maker chapters: - t: 0 title: Introduction to Copilot in Business Central - t: 77 title: Analytics Needs and the BI Triangle - t: 159 title: Announcing Analysis Assist with Copilot - t: 219 title: "Demo: Basic Analysis with Columns" - t: 280 title: Adding Sorting and Multiple Iterations - t: 358 title: Filtering and Semantic Understanding - t: 466 title: Grouping, Renaming, and Tab Management - t: 632 title: Data Privacy Discussion - t: 693 title: Real-World Customer Analysis Example and Copilot Mechanics - t: 941 title: Availability and Deployment Requirements - t: 1002 title: Responsible AI and Data Safety Principles - t: 1101 title: How to Access and Troubleshoot Copilot Features - t: 1214 title: Feedback Collection and Other Copilot Capabilities - t: 1330 title: Closing Remarks and Call to Action features: - name: Analysis Assist status: preview t: 139 verified: true status_source: video - name: Analyze List Action status: preview t: 239 verified: true status_source: video - name: Draft Tab Management status: preview t: 320 verified: true status_source: video - name: Semantic Understanding for Filters status: preview t: 418 verified: true status_source: video - name: Prompt Guide status: preview t: 502 verified: true status_source: video - name: Grouping and Pivoting status: preview t: 522 verified: true status_source: video - name: Data Privacy in Analysis Assist status: unclear t: 652 verified: false status_source: video - name: Copilot availability and deployment status: preview t: 961 verified: true status_source: video - name: Responsible AI and data safety status: unclear t: 1020 verified: false status_source: video - name: Copilot feature enablement and troubleshooting status: unclear t: 1101 verified: false status_source: video - name: Copilot for sales document entry status: unclear t: 1249 verified: false status_source: video - name: Copilot chat for data discovery and learning status: unclear t: 1249 verified: false status_source: video - name: Copilot for electronic invoice matching status: unclear t: 1269 verified: false status_source: video - name: Excel reports for finance and sales status: unclear t: 1290 verified: false status_source: video objects_mentioned: - table Item - table Customer Ledger quotes: - t: 139 text: that's why we're excited to announce the public preview of analysis assist check: exact - t: 159 text: with this new capability helps uh reduce the time it takes to get to identifying Trends uh anomalies in your business data uh simply check: exact - t: 179 text: by describing in a simple sentence how you want to structure your data uh you quickly get to insights instead of spending the time check: exact - t: 199 text: more people across the organization can uh make datadriven decisions themselves check: exact - t: 652 text: we don't send any of your data to co-pilot because that's not what's needed the only thing we actually send to co-pilot is the check: exact - t: 722 text: we just in a natural language sentence told copile what we wanted and uh now it comes back wow with an analysis with the check: exact - t: 861 text: I kind of like the idea that co-pilot helped me get started with my analysis but in the end I was in control check: exact - t: 901 text: co-pilot at this stage in preview will only work with fields that are shown on the page on the list page itself check: exact - t: 921 text: co-pilot here and the ability to analyze that list is available on all virtually all list pages and I believe worksheets as well in check: exact - t: 982 text: this has been released with 2024 release Wave 1 so you'll need to upgrade to version 24.0 or later check: exact - t: 1002 text: at this stage co-pilot is available uh with your business Central license at no additional cost check: exact - t: 1020 text: our promise to our customers is that their data is their data we do not use that data to train the AI models check: exact - t: 1081 text: ai is sometimes incorrect and that's why we always give our users the opportunity to review what co pilot has generated before check: fuzzy - t: 1173 text: because Azure open AI service is only available in uh certain regions but not all some of our customers on some environments will need check: exact --- # Introducing: AI-Powered Analysis with Copilot (2024 release wave 1) > Analysis Assist with Copilot in Business Central, in public preview with 2024 release wave 1 (version 24.0 or later). Users describe an analysis in natural language and Copilot builds columns, filters, sorting and grouping on list pages. Covers limits, availability, data privacy and admin requirements. [Watch on YouTube](https://www.youtube.com/watch?v=mHrY_OI0qNo) · Microsoft Dynamics 365 Business Central (YouTube) · 2024-04-04 · 23:07 · tier official · reviewed (checked by Opus) ## Overview The video introduces Analysis Assist, a Copilot capability in preview that lets users describe the analysis they want in a sentence instead of clicking through columns, filters, sorting and grouping by hand. The demo uses an Analyze action at the top of a list, shows draft tabs that can be iterated with back and forward arrows, and shows Copilot mapping the word "replacement" to a "substitution" field. A Prompt Guide lists example prompts. It also covers availability and safety. Copilot is for Business Central Online, version 24.0 or later, English only, and not in Canada. Only the schema is sent to Copilot, not customer data. Admins manage features on the Copilot and AI capabilities page. Other 2024 wave 1 Copilot items are briefly mentioned: sales line entry, chat, electronic invoice matching, and Excel reports. ## Key points - Analysis Assist is in preview. It works only on lists that already support analyzing data, on list pages and worksheets, using fields visible on the page. - It does not join data across tables. Copilot may add columns or features that were not requested, for example when pivoting. - Requires Business Central Online, version 24.0 or later, English language, and the user's permission to analyze. Not available in Canada. No extra cost with the license. - Generated tabs start as drafts with a dotted line. The tab is saved only when the user confirms it. - Only the schema (column descriptions) is sent to Copilot, not customer data. Customer data is not used to train models. - Where Azure OpenAI is not available in the region, customers must opt in to data movement outside the geographic boundary. Admins control features on the Copilot and AI capabilities page. - Review Copilot output before saving, because AI is sometimes incorrect. ## Chapters - [0:00](https://www.youtube.com/watch?v=mHrY_OI0qNo&t=0s) Introduction to Copilot in Business Central - [1:17](https://www.youtube.com/watch?v=mHrY_OI0qNo&t=77s) Analytics Needs and the BI Triangle - [2:39](https://www.youtube.com/watch?v=mHrY_OI0qNo&t=159s) Announcing Analysis Assist with Copilot - [3:39](https://www.youtube.com/watch?v=mHrY_OI0qNo&t=219s) Demo: Basic Analysis with Columns - [4:40](https://www.youtube.com/watch?v=mHrY_OI0qNo&t=280s) Adding Sorting and Multiple Iterations - [5:58](https://www.youtube.com/watch?v=mHrY_OI0qNo&t=358s) Filtering and Semantic Understanding - [7:46](https://www.youtube.com/watch?v=mHrY_OI0qNo&t=466s) Grouping, Renaming, and Tab Management - [10:32](https://www.youtube.com/watch?v=mHrY_OI0qNo&t=632s) Data Privacy Discussion - [11:33](https://www.youtube.com/watch?v=mHrY_OI0qNo&t=693s) Real-World Customer Analysis Example and Copilot Mechanics - [15:41](https://www.youtube.com/watch?v=mHrY_OI0qNo&t=941s) Availability and Deployment Requirements - [16:42](https://www.youtube.com/watch?v=mHrY_OI0qNo&t=1002s) Responsible AI and Data Safety Principles - [18:21](https://www.youtube.com/watch?v=mHrY_OI0qNo&t=1101s) How to Access and Troubleshoot Copilot Features - [20:14](https://www.youtube.com/watch?v=mHrY_OI0qNo&t=1214s) Feedback Collection and Other Copilot Capabilities - [22:10](https://www.youtube.com/watch?v=mHrY_OI0qNo&t=1330s) Closing Remarks and Call to Action ## Features | Feature | Status | At | Evidence | |---|---|---|---| | Analysis Assist | preview, demoed | [2:19](https://www.youtube.com/watch?v=mHrY_OI0qNo&t=139s) | "that's why we're excited to announce the public preview of analysis assist" ([2:19](https://www.youtube.com/watch?v=mHrY_OI0qNo&t=139s)) | | Analyze List Action | preview, demoed | [3:59](https://www.youtube.com/watch?v=mHrY_OI0qNo&t=239s) | "co-pilot at this stage in preview will only work with fields that are shown on the page" ([15:01](https://www.youtube.com/watch?v=mHrY_OI0qNo&t=901s)) | | Draft Tab Management | preview, demoed | [5:20](https://www.youtube.com/watch?v=mHrY_OI0qNo&t=320s) | "co-pilot at this stage in preview will only work with fields that are shown on the page" ([15:01](https://www.youtube.com/watch?v=mHrY_OI0qNo&t=901s)) | | Semantic Understanding for Filters | preview, demoed | [6:58](https://www.youtube.com/watch?v=mHrY_OI0qNo&t=418s) | "co-pilot at this stage in preview will only work with fields that are shown on the page" ([15:01](https://www.youtube.com/watch?v=mHrY_OI0qNo&t=901s)) | | Prompt Guide | preview, demoed | [8:22](https://www.youtube.com/watch?v=mHrY_OI0qNo&t=502s) | "co-pilot at this stage in preview will only work with fields that are shown on the page" ([15:01](https://www.youtube.com/watch?v=mHrY_OI0qNo&t=901s)) | | Grouping and Pivoting | preview, demoed | [8:42](https://www.youtube.com/watch?v=mHrY_OI0qNo&t=522s) | "co-pilot at this stage in preview will only work with fields that are shown on the page" ([15:01](https://www.youtube.com/watch?v=mHrY_OI0qNo&t=901s)) | | Data Privacy in Analysis Assist | status not stated | [10:52](https://www.youtube.com/watch?v=mHrY_OI0qNo&t=652s) | | | Copilot availability and deployment | preview | [16:01](https://www.youtube.com/watch?v=mHrY_OI0qNo&t=961s) | "it's also available in preview in English language only so you'll need to make sure" ([16:22](https://www.youtube.com/watch?v=mHrY_OI0qNo&t=982s)) | | Responsible AI and data safety | status not stated | [17:00](https://www.youtube.com/watch?v=mHrY_OI0qNo&t=1020s) | | | Copilot feature enablement and troubleshooting | status not stated | [18:21](https://www.youtube.com/watch?v=mHrY_OI0qNo&t=1101s) | | | Copilot for sales document entry | status not stated | [20:49](https://www.youtube.com/watch?v=mHrY_OI0qNo&t=1249s) | | | Copilot chat for data discovery and learning | status not stated | [20:49](https://www.youtube.com/watch?v=mHrY_OI0qNo&t=1249s) | | | Copilot for electronic invoice matching | status not stated | [21:09](https://www.youtube.com/watch?v=mHrY_OI0qNo&t=1269s) | | | Excel reports for finance and sales | status not stated | [21:30](https://www.youtube.com/watch?v=mHrY_OI0qNo&t=1290s) | | ## 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 27 "Item"](../objects/table/27.md) at [3:59](https://www.youtube.com/watch?v=mHrY_OI0qNo&t=239s) - table "Customer Ledger" at [11:33](https://www.youtube.com/watch?v=mHrY_OI0qNo&t=693s) Not found in BC28-30: table "Customer Ledger". ## Quotes - [2:19](https://www.youtube.com/watch?v=mHrY_OI0qNo&t=139s) "that's why we're excited to announce the public preview of analysis assist" - [2:39](https://www.youtube.com/watch?v=mHrY_OI0qNo&t=159s) "with this new capability helps uh reduce the time it takes to get to identifying Trends uh anomalies in your business data uh simply" - [2:59](https://www.youtube.com/watch?v=mHrY_OI0qNo&t=179s) "by describing in a simple sentence how you want to structure your data uh you quickly get to insights instead of spending the time" - [3:19](https://www.youtube.com/watch?v=mHrY_OI0qNo&t=199s) "more people across the organization can uh make datadriven decisions themselves" - [10:52](https://www.youtube.com/watch?v=mHrY_OI0qNo&t=652s) "we don't send any of your data to co-pilot because that's not what's needed the only thing we actually send to co-pilot is the" - [12:02](https://www.youtube.com/watch?v=mHrY_OI0qNo&t=722s) "we just in a natural language sentence told copile what we wanted and uh now it comes back wow with an analysis with the" - [14:21](https://www.youtube.com/watch?v=mHrY_OI0qNo&t=861s) "I kind of like the idea that co-pilot helped me get started with my analysis but in the end I was in control" - [15:01](https://www.youtube.com/watch?v=mHrY_OI0qNo&t=901s) "co-pilot at this stage in preview will only work with fields that are shown on the page on the list page itself" - [15:21](https://www.youtube.com/watch?v=mHrY_OI0qNo&t=921s) "co-pilot here and the ability to analyze that list is available on all virtually all list pages and I believe worksheets as well in" - [16:22](https://www.youtube.com/watch?v=mHrY_OI0qNo&t=982s) "this has been released with 2024 release Wave 1 so you'll need to upgrade to version 24.0 or later" - [16:42](https://www.youtube.com/watch?v=mHrY_OI0qNo&t=1002s) "at this stage co-pilot is available uh with your business Central license at no additional cost" - [17:00](https://www.youtube.com/watch?v=mHrY_OI0qNo&t=1020s) "our promise to our customers is that their data is their data we do not use that data to train the AI models" - [18:01](https://www.youtube.com/watch?v=mHrY_OI0qNo&t=1081s) "ai is sometimes incorrect and that's why we always give our users the opportunity to review what co pilot has generated before" - [19:33](https://www.youtube.com/watch?v=mHrY_OI0qNo&t=1173s) "because Azure open AI service is only available in uh certain regions but not all some of our customers on some environments will need" ## Disclaimers in the video - [2:19](https://www.youtube.com/watch?v=mHrY_OI0qNo&t=139s) preview: the public preview of analysis assist - [15:01](https://www.youtube.com/watch?v=mHrY_OI0qNo&t=901s) preview: co-pilot at this stage in preview will only work with fields that are shown on the page - [16:22](https://www.youtube.com/watch?v=mHrY_OI0qNo&t=982s) not-in-this-release: it's also being rolled out for uh all environment localizations with the exception of Canada for regulatory reasons - [16:22](https://www.youtube.com/watch?v=mHrY_OI0qNo&t=982s) preview: it's also available in preview in English language only Presenters (as heard): Mike Borj Cardon, Thomas Jensen, Kenny Paban.