---
id: video/rm-FstU_I80
type: video
title: 20260831 - Business Central MCP Server, standard and custom
summary: "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."
tier: community
language: en
tags:
  - model context protocol
  - mcp server
  - copilot studio
  - business central integration
  - reusability
  - standardization
  - ai integration
  - llm connectivity
  - api exposure
  - configuration
  - dynamic vs static
  - read-only operations
system: copilot
review:
  state: reviewed
  by: opus
  at: "2026-10-07T23:19:38.493Z"
  flags: []
generated:
  at: "2026-10-07T23:19:38.565Z"
  pipeline: 0.2.0
  prompts:
    extract-video: 1
    summarize-video: 2
  input_hash: aec130305ee5802c67266391e2f21b3242803247068fdc77a583c759ed30b6f6
evidence:
  - kind: video
    url: https://www.youtube.com/watch?v=rm-FstU_I80&t=1177s
    title: "MCP Server Standard for Business Central: preview"
    date: "2026-09-07T12:36:05.000Z"
    commit: null
    t: 1177
    quote: The MCP server standard uh is in public preview from 27.1
  - kind: video
    url: https://www.youtube.com/watch?v=rm-FstU_I80&t=1209s
    title: "MCP Server Proxy: preview"
    date: "2026-09-07T12:36:05.000Z"
    commit: null
    t: 1209
    quote: 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
  - kind: video
    url: https://www.youtube.com/watch?v=rm-FstU_I80&t=425s
    title: 20260831 - Business Central MCP Server, standard and custom
    date: "2026-09-07T12:36:05.000Z"
    commit: null
    t: 425
    quote: protocol is something similar to that we have the same protocol to connect every item every model large language
  - kind: video
    url: https://www.youtube.com/watch?v=rm-FstU_I80&t=597s
    title: 20260831 - Business Central MCP Server, standard and custom
    date: "2026-09-07T12:36:05.000Z"
    commit: null
    t: 597
    quote: The MCP is an open protocol. Remember that the MCP was created by Anthropic.
  - kind: video
    url: https://www.youtube.com/watch?v=rm-FstU_I80&t=821s
    title: 20260831 - Business Central MCP Server, standard and custom
    date: "2026-09-07T12:36:05.000Z"
    commit: null
    t: 821
    quote: components that we can use in copilot studio are resources and tools
  - kind: video
    url: https://www.youtube.com/watch?v=rm-FstU_I80&t=831s
    title: 20260831 - Business Central MCP Server, standard and custom
    date: "2026-09-07T12:36:05.000Z"
    commit: null
    t: 831
    quote: if you want to use business central with copilot the mcp server for business central
  - kind: video
    url: https://www.youtube.com/watch?v=rm-FstU_I80&t=831s
    title: 20260831 - Business Central MCP Server, standard and custom
    date: "2026-09-07T12:36:05.000Z"
    commit: null
    t: 831
    quote: if you want to use Business Central with Copilot the MCP server for Business Central uh in Copilot Studio, you only can use tools
links:
  learn: []
  objects:
    - object/table/18
  features: []
  topics: []
  localizations: []
  videos: []
  posts: []
  guidelines: []
video_id: rm-FstU_I80
channel: yt-areopa
source_name: Areopa webinars
url: https://www.youtube.com/watch?v=rm-FstU_I80
published_at: "2026-09-07T12:36:05.000Z"
duration_s: 3491
captions: derived
audience:
  - developer
  - functional consultant
  - administrator
chapters:
  - t: 0
    title: Introduction and Agenda
  - t: 156
    title: Presenter Introduction and Session Overview
  - t: 330
    title: What is Model Context Protocol (MCP) and Open Standard
  - t: 597
    title: MCP as Open Standard and Reusability
  - t: 708
    title: MCP Components and Copilot Studio Support
  - t: 887
    title: MCP architecture and server options
  - t: 1111
    title: MCP server types and status
  - t: 1261
    title: MCP configuration strategies
  - t: 1370
    title: Dynamic and static tool configuration
  - t: 1673
    title: Security, authentication and MCP server integration
  - t: 1842
    title: MCP Server Integration with Copilot Studio and tool discovery
  - t: 2040
    title: MCP server configuration and agent query execution
  - t: 2280
    title: Visualizations, write operations limitations and MCP design
  - t: 2443
    title: MCP advantages, disadvantages and validate feature
  - t: 2596
    title: MCP in VS Code, query exposure and configuration management
  - t: 2825
    title: MCP proxy, cloud integration and cross-platform usage
  - t: 3100
    title: Business Central admin MCP and future roadmap
  - t: 3233
    title: Q&A and closing remarks
features:
  - name: Business Central MCP Server
    status: unclear
    t: 167
    verified: false
    status_source: video
  - name: MCP Resources Component
    status: unclear
    t: 831
    verified: false
    status_source: video
  - name: MCP Tools Component
    status: unclear
    t: 731
    verified: false
    status_source: video
  - name: Model Context Protocol (MCP)
    status: unclear
    t: 330
    verified: false
    status_source: video
  - name: MCP Prompts Component
    status: unclear
    t: 731
    verified: false
    status_source: video
  - name: MCP Sampling, Elicitation and Apps
    status: unclear
    t: 756
    verified: false
    status_source: video
  - name: MCP Server Standard for Business Central
    status: preview
    t: 1122
    verified: true
    status_source: video
  - name: MCP Server Proxy
    status: preview
    t: 1209
    verified: true
    status_source: video
  - name: MCP Server for Administration
    status: unclear
    t: 1247
    verified: false
    status_source: video
  - name: Dynamic Tool Configuration
    status: unclear
    t: 1396
    verified: false
    status_source: video
  - name: Static Configuration Mode
    status: unclear
    t: 1658
    verified: false
    status_source: video
  - name: MCP Default Read-Only Access
    status: unclear
    t: 1786
    verified: false
    status_source: video
  - name: MCP Server Connection in Copilot Studio
    status: unclear
    t: 1842
    verified: false
    status_source: video
  - name: Model Context Protocol (MCP) Discovery in Copilot Studio
    status: unclear
    t: 1958
    verified: false
    status_source: video
  - name: MCP Tool Search, Describe, and Invoke Actions
    status: unclear
    t: 2148
    verified: false
    status_source: video
  - name: Copilot Agent Query Execution Against Business Central
    status: unclear
    t: 2201
    verified: false
    status_source: video
  - name: AI-Generated Visualizations in Copilot Studio
    status: unclear
    t: 2301
    verified: false
    status_source: video
  - name: MCP Read-Only Constraint for Write Operations
    status: unclear
    t: 2372
    verified: false
    status_source: video
  - name: MCP Native AI Tool Design
    status: unclear
    t: 2417
    verified: false
    status_source: video
  - name: Validate feature for API exposure
    status: unclear
    t: 2532
    verified: false
    status_source: video
  - name: Connection string configuration
    status: unclear
    t: 2569
    verified: false
    status_source: video
  - name: MCP integration with VS Code
    status: unclear
    t: 2596
    verified: false
    status_source: video
  - name: Query exposure in MCP
    status: unclear
    t: 2702
    verified: false
    status_source: video
  - name: Page and API selection for exposure
    status: unclear
    t: 2738
    verified: false
    status_source: video
  - name: Configuration export and import
    status: unclear
    t: 2800
    verified: false
    status_source: video
  - name: Copilot Studio tool selections
    status: unclear
    t: 3195
    verified: false
    status_source: video
  - name: Power BI integration with MCP agents
    status: unclear
    t: 3338
    verified: false
    status_source: video
  - name: Custom APIs for custom fields
    status: unclear
    t: 3362
    verified: false
    status_source: video
objects_mentioned:
  - other Model Context Protocol configuration
  - table customer
  - other mcp.json
  - api Business Central admin API
quotes:
  - t: 425
    text: protocol is something similar to that we have the same protocol to connect every item every model large language
    check: fuzzy
  - t: 597
    text: The MCP is an open protocol. Remember that the MCP was created by Anthropic.
    check: exact
  - t: 821
    text: components that we can use in copilot studio are resources and tools
    check: fuzzy
  - t: 831
    text: if you want to use business central with copilot the mcp server for business central
    check: fuzzy
  - t: 831
    text: if you want to use Business Central with Copilot the MCP server for Business Central uh in Copilot Studio, you only can use tools
    check: exact
---

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

[Watch on YouTube](https://www.youtube.com/watch?v=rm-FstU_I80) · Areopa webinars · 2026-09-07 · 58:11 · tier community · reviewed (checked by Opus)

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

## Chapters

- [0:00](https://www.youtube.com/watch?v=rm-FstU_I80&t=0s) Introduction and Agenda
- [2:36](https://www.youtube.com/watch?v=rm-FstU_I80&t=156s) Presenter Introduction and Session Overview
- [5:30](https://www.youtube.com/watch?v=rm-FstU_I80&t=330s) What is Model Context Protocol (MCP) and Open Standard
- [9:57](https://www.youtube.com/watch?v=rm-FstU_I80&t=597s) MCP as Open Standard and Reusability
- [11:48](https://www.youtube.com/watch?v=rm-FstU_I80&t=708s) MCP Components and Copilot Studio Support
- [14:47](https://www.youtube.com/watch?v=rm-FstU_I80&t=887s) MCP architecture and server options
- [18:31](https://www.youtube.com/watch?v=rm-FstU_I80&t=1111s) MCP server types and status
- [21:01](https://www.youtube.com/watch?v=rm-FstU_I80&t=1261s) MCP configuration strategies
- [22:50](https://www.youtube.com/watch?v=rm-FstU_I80&t=1370s) Dynamic and static tool configuration
- [27:53](https://www.youtube.com/watch?v=rm-FstU_I80&t=1673s) Security, authentication and MCP server integration
- [30:42](https://www.youtube.com/watch?v=rm-FstU_I80&t=1842s) MCP Server Integration with Copilot Studio and tool discovery
- [34:00](https://www.youtube.com/watch?v=rm-FstU_I80&t=2040s) MCP server configuration and agent query execution
- [38:00](https://www.youtube.com/watch?v=rm-FstU_I80&t=2280s) Visualizations, write operations limitations and MCP design
- [40:43](https://www.youtube.com/watch?v=rm-FstU_I80&t=2443s) MCP advantages, disadvantages and validate feature
- [43:16](https://www.youtube.com/watch?v=rm-FstU_I80&t=2596s) MCP in VS Code, query exposure and configuration management
- [47:05](https://www.youtube.com/watch?v=rm-FstU_I80&t=2825s) MCP proxy, cloud integration and cross-platform usage
- [51:40](https://www.youtube.com/watch?v=rm-FstU_I80&t=3100s) Business Central admin MCP and future roadmap
- [53:53](https://www.youtube.com/watch?v=rm-FstU_I80&t=3233s) Q&A and closing remarks

## Features

| Feature | Status | At | Evidence |
|---|---|---|---|
| Business Central MCP Server | status not stated | [2:47](https://www.youtube.com/watch?v=rm-FstU_I80&t=167s) |  |
| MCP Resources Component | status not stated | [13:51](https://www.youtube.com/watch?v=rm-FstU_I80&t=831s) |  |
| MCP Tools Component | status not stated | [12:11](https://www.youtube.com/watch?v=rm-FstU_I80&t=731s) |  |
| Model Context Protocol (MCP) | status not stated | [5:30](https://www.youtube.com/watch?v=rm-FstU_I80&t=330s) |  |
| MCP Prompts Component | status not stated | [12:11](https://www.youtube.com/watch?v=rm-FstU_I80&t=731s) |  |
| MCP Sampling, Elicitation and Apps | status not stated | [12:36](https://www.youtube.com/watch?v=rm-FstU_I80&t=756s) |  |
| MCP Server Standard for Business Central | preview, demoed | [18:42](https://www.youtube.com/watch?v=rm-FstU_I80&t=1122s) | "The MCP server standard uh is in public preview from 27.1" ([19:37](https://www.youtube.com/watch?v=rm-FstU_I80&t=1177s)) |
| MCP Server Proxy | preview | [20:09](https://www.youtube.com/watch?v=rm-FstU_I80&t=1209s) | "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](https://www.youtube.com/watch?v=rm-FstU_I80&t=1209s)) |
| MCP Server for Administration | status not stated | [20:47](https://www.youtube.com/watch?v=rm-FstU_I80&t=1247s) |  |
| Dynamic Tool Configuration | status not stated, demoed | [23:16](https://www.youtube.com/watch?v=rm-FstU_I80&t=1396s) |  |
| Static Configuration Mode | status not stated, demoed | [27:38](https://www.youtube.com/watch?v=rm-FstU_I80&t=1658s) |  |
| MCP Default Read-Only Access | status not stated | [29:46](https://www.youtube.com/watch?v=rm-FstU_I80&t=1786s) |  |
| MCP Server Connection in Copilot Studio | status not stated, demoed | [30:42](https://www.youtube.com/watch?v=rm-FstU_I80&t=1842s) |  |
| Model Context Protocol (MCP) Discovery in Copilot Studio | status not stated, demoed | [32:38](https://www.youtube.com/watch?v=rm-FstU_I80&t=1958s) |  |
| MCP Tool Search, Describe, and Invoke Actions | status not stated, demoed | [35:48](https://www.youtube.com/watch?v=rm-FstU_I80&t=2148s) |  |
| Copilot Agent Query Execution Against Business Central | status not stated, demoed | [36:41](https://www.youtube.com/watch?v=rm-FstU_I80&t=2201s) |  |
| AI-Generated Visualizations in Copilot Studio | status not stated, demoed | [38:21](https://www.youtube.com/watch?v=rm-FstU_I80&t=2301s) |  |
| MCP Read-Only Constraint for Write Operations | status not stated, demoed | [39:32](https://www.youtube.com/watch?v=rm-FstU_I80&t=2372s) |  |
| MCP Native AI Tool Design | status not stated | [40:17](https://www.youtube.com/watch?v=rm-FstU_I80&t=2417s) |  |
| Validate feature for API exposure | status not stated | [42:12](https://www.youtube.com/watch?v=rm-FstU_I80&t=2532s) |  |
| Connection string configuration | status not stated, demoed | [42:49](https://www.youtube.com/watch?v=rm-FstU_I80&t=2569s) |  |
| MCP integration with VS Code | status not stated, demoed | [43:16](https://www.youtube.com/watch?v=rm-FstU_I80&t=2596s) |  |
| Query exposure in MCP | status not stated | [45:02](https://www.youtube.com/watch?v=rm-FstU_I80&t=2702s) |  |
| Page and API selection for exposure | status not stated | [45:38](https://www.youtube.com/watch?v=rm-FstU_I80&t=2738s) |  |
| Configuration export and import | status not stated, demoed | [46:40](https://www.youtube.com/watch?v=rm-FstU_I80&t=2800s) |  |
| Copilot Studio tool selections | status not stated | [53:15](https://www.youtube.com/watch?v=rm-FstU_I80&t=3195s) |  |
| Power BI integration with MCP agents | status not stated | [55:38](https://www.youtube.com/watch?v=rm-FstU_I80&t=3338s) |  |
| Custom APIs for custom fields | status not stated | [56:02](https://www.youtube.com/watch?v=rm-FstU_I80&t=3362s) |  |

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

- other "Model Context Protocol configuration" at [23:03](https://www.youtube.com/watch?v=rm-FstU_I80&t=1383s)
- [table 18 "Customer"](../objects/table/18.md) at [34:00](https://www.youtube.com/watch?v=rm-FstU_I80&t=2040s)
- other "mcp.json" at [43:27](https://www.youtube.com/watch?v=rm-FstU_I80&t=2607s)
- api "Business Central admin API" at [52:06](https://www.youtube.com/watch?v=rm-FstU_I80&t=3126s)

## Quotes

- [7:05](https://www.youtube.com/watch?v=rm-FstU_I80&t=425s) "protocol is something similar to that we have the same protocol to connect every item every model large language"
- [9:57](https://www.youtube.com/watch?v=rm-FstU_I80&t=597s) "The MCP is an open protocol. Remember that the MCP was created by Anthropic."
- [13:41](https://www.youtube.com/watch?v=rm-FstU_I80&t=821s) "components that we can use in copilot studio are resources and tools"
- [13:51](https://www.youtube.com/watch?v=rm-FstU_I80&t=831s) "if you want to use business central with copilot the mcp server for business central"
- [13:51](https://www.youtube.com/watch?v=rm-FstU_I80&t=831s) "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](https://www.youtube.com/watch?v=rm-FstU_I80&t=860s) 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](https://www.youtube.com/watch?v=rm-FstU_I80&t=1190s) preview: The MCP server standard uh is in public preview from 27.1
- [20:09](https://www.youtube.com/watch?v=rm-FstU_I80&t=1209s) preview: Experimental. If you want to use the MCP server with cloud up to you, but it's experimental
- [20:20](https://www.youtube.com/watch?v=rm-FstU_I80&t=1220s) other: It's not supported by Microsoft
- [41:13](https://www.youtube.com/watch?v=rm-FstU_I80&t=2473s) preview: it's not it's still maturing. Um it's not something very um tested
- [45:13](https://www.youtube.com/watch?v=rm-FstU_I80&t=2713s) preview: it's not uh working uh for now it's not working um perfectly
- [48:01](https://www.youtube.com/watch?v=rm-FstU_I80&t=2881s) preview: this is the experimental solution, right? This Remember, this is the experimental. It's not supported by Microsoft.
- [53:41](https://www.youtube.com/watch?v=rm-FstU_I80&t=3221s) 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.