--- id: video/4HE3BBCcV84 type: video title: MCP Server and API Queries (2026 release wave 1) summary: The Business Central MCP server now supports API queries, as shown in the 2026 release wave 1 video. The analytics API queries behind the Power BI apps can be picked by choosing object type "query" in the MCP server configuration, so external agents can use aggregations and analytics. The video says support came in version 28.2 (captioned "22 28.2") and points to the analytics API reference at aka.ms/bcintegration for agent knowledge. tier: official language: en tags: - mcp server - api queries - power bi apps - external agents - analytics apis - agent development system: copilot review: state: reviewed by: opus at: "2026-10-07T22:47:24.099Z" flags: [] generated: at: "2026-10-07T22:47:24.131Z" pipeline: 0.2.0 prompts: extract-video: 1 summarize-video: 2 input_hash: 1b6ce04256d29fd1069f2022435fbcfd2dc451e2a979b4768bf0f8dca426233f evidence: - kind: video url: https://www.youtube.com/watch?v=4HE3BBCcV84&t=97s title: "API queries in MCP server: generally available" date: "2026-07-07T14:00:18.000Z" commit: null t: 97 quote: API queries are the foundation for our Power BI apps, and this is now available in Business Central uh MCP server - kind: video url: https://www.youtube.com/watch?v=4HE3BBCcV84&t=5s title: MCP Server and API Queries (2026 release wave 1) date: "2026-07-07T14:00:18.000Z" commit: null t: 5 quote: We have two new things. One is support for API queries, that's this video, and then we have opened up for all Microsoft's APIs - kind: video url: https://www.youtube.com/watch?v=4HE3BBCcV84&t=36s title: MCP Server and API Queries (2026 release wave 1) date: "2026-07-07T14:00:18.000Z" commit: null t: 36 quote: We added Power BI apps for most functional areas in Business Central, and the foundation, the data foundation for these reports or apps uh - kind: video url: https://www.youtube.com/watch?v=4HE3BBCcV84&t=47s title: MCP Server and API Queries (2026 release wave 1) date: "2026-07-07T14:00:18.000Z" commit: null t: 47 quote: Those API queries are now also available for your external agents. So, if you want to include things like aggregations or analytics, - kind: video url: https://www.youtube.com/watch?v=4HE3BBCcV84&t=69s title: MCP Server and API Queries (2026 release wave 1) date: "2026-07-07T14:00:18.000Z" commit: null t: 69 quote: In the release wave one for Business Central here in 2026, uh highlighted in italic, you can see what we already shipped in April, - kind: video url: https://www.youtube.com/watch?v=4HE3BBCcV84&t=110s title: MCP Server and API Queries (2026 release wave 1) date: "2026-07-07T14:00:18.000Z" commit: null t: 110 quote: I have um here a MCP server configuration, and if I go down here under object type and choose query, when I then choose - kind: video url: https://www.youtube.com/watch?v=4HE3BBCcV84&t=139s title: MCP Server and API Queries (2026 release wave 1) date: "2026-07-07T14:00:18.000Z" commit: null t: 139 quote: These are all grouped under the API group analytics. And even though they show version 0.5 and version 1 is just for backwards compatibility, - kind: video url: https://www.youtube.com/watch?v=4HE3BBCcV84&t=225s title: MCP Server and API Queries (2026 release wave 1) date: "2026-07-07T14:00:18.000Z" commit: null t: 225 quote: you can probably even use that reference as instructions or knowledge to your agents. Maybe you want to point to that in Co-pilot Studio links: learn: [] objects: [] features: [] topics: [] localizations: [] videos: [] posts: [] guidelines: [] video_id: 4HE3BBCcV84 channel: yt-microsoft source_name: Microsoft Dynamics 365 Business Central (YouTube) url: https://www.youtube.com/watch?v=4HE3BBCcV84 published_at: "2026-07-07T14:00:18.000Z" duration_s: 340 captions: full audience: - developer - administrator - functional consultant chapters: - t: 0 title: Introduction to API queries and MCP server - t: 21 title: Business value of API queries for external agents - t: 69 title: Release wave 1 updates and API queries availability - t: 97 title: "Demo: enabling API queries in MCP server configuration" - t: 172 title: Documentation and Power BI app analytics reference - t: 245 title: API use cases across functional areas - t: 272 title: Resources and next steps features: - name: API queries in MCP server status: ga t: 5 verified: true status_source: video - name: Analytics API reference documentation status: unclear t: 172 verified: false status_source: video - name: MCP server configuration for object type query status: unclear t: 97 verified: false status_source: video objects_mentioned: - query GL account category quotes: - t: 5 text: We have two new things. One is support for API queries, that's this video, and then we have opened up for all Microsoft's APIs check: exact - t: 36 text: We added Power BI apps for most functional areas in Business Central, and the foundation, the data foundation for these reports or apps uh check: exact - t: 47 text: Those API queries are now also available for your external agents. So, if you want to include things like aggregations or analytics, check: exact - t: 69 text: In the release wave one for Business Central here in 2026, uh highlighted in italic, you can see what we already shipped in April, check: exact - t: 110 text: I have um here a MCP server configuration, and if I go down here under object type and choose query, when I then choose check: exact - t: 139 text: These are all grouped under the API group analytics. And even though they show version 0.5 and version 1 is just for backwards compatibility, check: exact - t: 225 text: you can probably even use that reference as instructions or knowledge to your agents. Maybe you want to point to that in Co-pilot Studio check: exact --- # MCP Server and API Queries (2026 release wave 1) > The Business Central MCP server now supports API queries, as shown in the 2026 release wave 1 video. The analytics API queries behind the Power BI apps can be picked by choosing object type "query" in the MCP server configuration, so external agents can use aggregations and analytics. The video says support came in version 28.2 (captioned "22 28.2") and points to the analytics API reference at aka.ms/bcintegration for agent knowledge. [Watch on YouTube](https://www.youtube.com/watch?v=4HE3BBCcV84) · Microsoft Dynamics 365 Business Central (YouTube) · 2026-07-07 · 5:40 · tier official · reviewed (checked by Opus) ## Overview The video explains that Power BI apps for most functional areas in Business Central are built on API queries, and that these queries are now available through the MCP server for external agents. This lets agent developers use aggregations and analytics data, not only the other APIs already opened up. The demo shows an MCP server configuration where the object type is set to query. The analytics API queries appear grouped under the API group analytics, including GL account category, finance and inventory related queries. The video also points to the analytics API reference documentation, which covers semantic models, calculations and use cases across areas such as manufacturing, sales and finance, and suggests using it as knowledge for agents, for example in Copilot Studio. ## Key points - API queries are supported in the MCP server and are the data foundation of the Power BI apps for most functional areas. - The video says API query support arrived in version 28.2 (captioned as '22 28.2'), together with support for all APIs, which is covered in a separate video. - In the MCP server configuration, choose query as object type and open the object ID lookup to see the analytics API queries, grouped under the API group analytics. - Versions 0.5 and 1 both appear, and the presenter mentions backwards compatibility; choose the highest numbered version of the API. - The analytics API reference (aka.ms/bcintegration) documents how the APIs are used in the Power BI apps, with semantic models, calculations and use cases for manufacturing, sales and finance. - The reference can be used as instructions or knowledge for agents, for example by pointing Copilot Studio to it. - General MCP server documentation is at aka.ms/bcmcp, and there is a 'getting started with MCP server' video playlist. ## Chapters - [0:00](https://www.youtube.com/watch?v=4HE3BBCcV84&t=0s) Introduction to API queries and MCP server - [0:21](https://www.youtube.com/watch?v=4HE3BBCcV84&t=21s) Business value of API queries for external agents - [1:09](https://www.youtube.com/watch?v=4HE3BBCcV84&t=69s) Release wave 1 updates and API queries availability - [1:37](https://www.youtube.com/watch?v=4HE3BBCcV84&t=97s) Demo: enabling API queries in MCP server configuration - [2:52](https://www.youtube.com/watch?v=4HE3BBCcV84&t=172s) Documentation and Power BI app analytics reference - [4:05](https://www.youtube.com/watch?v=4HE3BBCcV84&t=245s) API use cases across functional areas - [4:32](https://www.youtube.com/watch?v=4HE3BBCcV84&t=272s) Resources and next steps ## Features | Feature | Status | At | Evidence | |---|---|---|---| | API queries in MCP server | generally available, demoed | [0:05](https://www.youtube.com/watch?v=4HE3BBCcV84&t=5s) | "API queries are the foundation for our Power BI apps, and this is now available in Business Central uh MCP server" ([1:37](https://www.youtube.com/watch?v=4HE3BBCcV84&t=97s)) | | Analytics API reference documentation | status not stated | [2:52](https://www.youtube.com/watch?v=4HE3BBCcV84&t=172s) | | | MCP server configuration for object type query | status not stated, demoed | [1:37](https://www.youtube.com/watch?v=4HE3BBCcV84&t=97s) | | ## 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 "GL account category" at [2:07](https://www.youtube.com/watch?v=4HE3BBCcV84&t=127s) Not found in BC28-30: query "GL account category". ## Quotes - [0:05](https://www.youtube.com/watch?v=4HE3BBCcV84&t=5s) "We have two new things. One is support for API queries, that's this video, and then we have opened up for all Microsoft's APIs" - [0:36](https://www.youtube.com/watch?v=4HE3BBCcV84&t=36s) "We added Power BI apps for most functional areas in Business Central, and the foundation, the data foundation for these reports or apps uh" - [0:47](https://www.youtube.com/watch?v=4HE3BBCcV84&t=47s) "Those API queries are now also available for your external agents. So, if you want to include things like aggregations or analytics," - [1:09](https://www.youtube.com/watch?v=4HE3BBCcV84&t=69s) "In the release wave one for Business Central here in 2026, uh highlighted in italic, you can see what we already shipped in April," - [1:50](https://www.youtube.com/watch?v=4HE3BBCcV84&t=110s) "I have um here a MCP server configuration, and if I go down here under object type and choose query, when I then choose" - [2:19](https://www.youtube.com/watch?v=4HE3BBCcV84&t=139s) "These are all grouped under the API group analytics. And even though they show version 0.5 and version 1 is just for backwards compatibility," - [3:45](https://www.youtube.com/watch?v=4HE3BBCcV84&t=225s) "you can probably even use that reference as instructions or knowledge to your agents. Maybe you want to point to that in Co-pilot Studio"