videoCopilot & Agentscommunity - not Microsoftreviewed - checked by Opus

20260831 - Business Central MCP Server, standard and custom

Business Central MCP server (standard, public preview from 27.1) used with Copilot Studio: dynamic vs static tool configuration, read-only default, connection string reuse, VS Code, an experimental unsupported proxy, and the admin MCP. Demos show read queries; write operations need static configuration.

  1. 0:00 Introduction and Agenda
  2. 2:36 Presenter Introduction and Session Overview
  3. 5:30 What is Model Context Protocol (MCP) and Open Standard
  4. 9:57 MCP as Open Standard and Reusability
  5. 11:48 MCP Components and Copilot Studio Support
  6. 14:47 MCP architecture and server options
  7. 18:31 MCP server types and status
  8. 21:01 MCP configuration strategies
  9. 22:50 Dynamic and static tool configuration
  10. 27:53 Security, authentication and MCP server integration
  11. 30:42 MCP Server Integration with Copilot Studio and tool discovery
  12. 34:00 MCP server configuration and agent query execution
  13. 38:00 Visualizations, write operations limitations and MCP design
  14. 40:43 MCP advantages, disadvantages and validate feature
  15. 43:16 MCP in VS Code, query exposure and configuration management
  16. 47:05 MCP proxy, cloud integration and cross-platform usage
  17. 51:40 Business Central admin MCP and future roadmap
  18. 53:53 Q&A and closing remarks
video Areopa webinars · 2026-09-07Watch on YouTube

Overview

The Areopa webinar explains the Model Context Protocol, an open standard created by Anthropic, and how Business Central implements it as an MCP server. In Copilot Studio only the tools component is supported for Business Central. Resources are being worked on and are expected in later minor versions.

The presenter demos adding the Business Central MCP server in Copilot Studio by choosing environment, MCP server configuration and company. The default dynamic configuration exposes search, describe and invoke and is read-only. Write scenarios need a static configuration with explicitly chosen APIs and permissions. The session also covers the validate feature, connection string reuse, VS Code with mcp.json, configuration export and import, query exposure, an experimental proxy for cloud tools, and an MCP for administrators.

Key points

  • The standard Business Central MCP server is in public preview from 27.1. In Copilot Studio only tools are supported, not resources.
  • The default configuration is read-only, for security. Dynamic mode exposes three tools: search, describe and invoke.
  • Write scenarios (customers, sales orders, purchase orders) need static configuration. You pick the APIs and actions and set permissions for each.
  • Adding the server in Copilot Studio asks for three inputs: environment, MCP server configuration and company. Only active configurations can be selected.
  • The MCP connection string can be copied and reused outside Copilot Studio, for example in VS Code via mcp.json. Configurations can be exported from sandbox and imported to production.
  • The MCP proxy for cloud tools is experimental and not supported by Microsoft. Query exposure was described as not yet working perfectly.
  • Advice: do not expose all APIs. Custom fields need custom APIs, with tooltips and captions that give the agent context.

Features

Feature Status At Evidence
Business Central MCP Server status not stated 2:47
MCP Resources Component status not stated 13:51
MCP Tools Component status not stated 12:11
Model Context Protocol (MCP) status not stated 5:30
MCP Prompts Component status not stated 12:11
MCP Sampling, Elicitation and Apps status not stated 12:36
MCP Server Standard for Business Central preview, demoed 18:42 “The MCP server standard uh is in public preview from 27.1” (19:37)
MCP Server Proxy preview 20:09 “This is very important. Experimental. If you want to use the MCP server with cloud up to you, but it’s experimental. It’s not supported” (20:09)
MCP Server for Administration status not stated 20:47
Dynamic Tool Configuration status not stated, demoed 23:16
Static Configuration Mode status not stated, demoed 27:38
MCP Default Read-Only Access status not stated 29:46
MCP Server Connection in Copilot Studio status not stated, demoed 30:42
Model Context Protocol (MCP) Discovery in Copilot Studio status not stated, demoed 32:38
MCP Tool Search, Describe, and Invoke Actions status not stated, demoed 35:48
Copilot Agent Query Execution Against Business Central status not stated, demoed 36:41
AI-Generated Visualizations in Copilot Studio status not stated, demoed 38:21
MCP Read-Only Constraint for Write Operations status not stated, demoed 39:32
MCP Native AI Tool Design status not stated 40:17
Validate feature for API exposure status not stated 42:12
Connection string configuration status not stated, demoed 42:49
MCP integration with VS Code status not stated, demoed 43:16
Query exposure in MCP status not stated 45:02
Page and API selection for exposure status not stated 45:38
Configuration export and import status not stated, demoed 46:40
Copilot Studio tool selections status not stated 53:15
Power BI integration with MCP agents status not stated 55:38
Custom APIs for custom fields status not stated 56:02

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.

Quotes

  • 7:05 “protocol is something similar to that we have the same protocol to connect every item every model large language”
  • 9:57 “The MCP is an open protocol. Remember that the MCP was created by Anthropic.”
  • 13:41 “components that we can use in copilot studio are resources and tools”
  • 13:51 “if you want to use business central with copilot the mcp server for business central”
  • 13:51 “if you want to use Business Central with Copilot the MCP server for Business Central uh in Copilot Studio, you only can use tools”

Disclaimers in the video

  • 14:20 coming-later: I suppose in a couple of versions or minor versions, probably you can use the resources because the team is working in use this resources, but for now we only can use tools
  • 19:50 preview: The MCP server standard uh is in public preview from 27.1
  • 20:09 preview: Experimental. If you want to use the MCP server with cloud up to you, but it’s experimental
  • 20:20 other: It’s not supported by Microsoft
  • 41:13 preview: it’s not it’s still maturing. Um it’s not something very um tested
  • 45:13 preview: it’s not uh working uh for now it’s not working um perfectly
  • 48:01 preview: this is the experimental solution, right? This Remember, this is the experimental. It’s not supported by Microsoft.
  • 53:41 preview: new tool selections from uh, from Copilot Studio is not public. It’s not uh in all the environments

Presenters (as heard): Fred Hector, Roberto Corella, Roberto.