Microsoft has introduced support for API queries in the MCP server of Business Central, enabling external agents to access data foundations used in Power BI apps. This update facilitates advanced analytics and aggregations, with comprehensive documentation available to help users leverage these APIs effectively. The release is part of the 2026 wave one update, enhancing integration and data analysis capabilities.
Microsoft has recently announced new features for the MCP server in Business Central, focusing on enhanced support for API queries. This update is part of the 2026 release wave one and aims to empower users and external agents with better data access and analytics capabilities.
This article explores the new support for API queries, its business value, how to enable it, and the resources available to help users make the most of these enhancements.
Two significant additions have been made to the MCP server in Business Central:
These features are designed to improve data integration and analytics, particularly in conjunction with Power BI apps.
API queries serve as the foundational data layer for Power BI apps across various functional areas in Business Central. By enabling API queries in the MCP server, Microsoft allows external agents to access these data sets, facilitating advanced analytics and aggregations.
This capability is crucial for organizations looking to enhance their reporting and decision-making processes by leveraging real-time data insights through Power BI.
The 2026 release wave one for Business Central introduced these features, with the initial shipment in April and further enhancements in version 22.28.2. The key highlights include:
Enabling API queries in the MCP server is straightforward:
These APIs cover various domains such as finance (e.g., GL account category), inventory, and more. Although some APIs show version 0.5, the highest available version should be selected for use.
This setup allows users to integrate these queries into their agents and analytics workflows seamlessly.
Microsoft provides comprehensive documentation to support users in utilizing these APIs effectively:
This detailed guidance helps users understand the types of analyses possible and how to implement them in their environments.
Additionally, the documentation outlines the relevance of each API to different business areas such as manufacturing, sales, and finance, including cases where APIs serve multiple domains.
For those interested in exploring more about MCP server investments and capabilities, Microsoft offers a full playlist titled "Getting Started with MCP Server." This playlist includes this video and others related to MCP server features.
Further documentation on MCP server configurations and operations is available at aka.ms/bcmcp.
Before diving deep into the documentation or Microsoft Learn, it is recommended to watch the companion video on opening up all APIs to fully understand the scope and potential of MCP server enhancements.
The introduction of API query support in the MCP server of Business Central marks a significant step forward in enabling advanced analytics and integration with Power BI. By providing external agents access to these foundational data queries, Microsoft empowers organizations to enhance their reporting, analytics, and decision-making capabilities.
With comprehensive documentation and resources available, users can quickly adopt these features and unlock new insights from their Business Central data.
For more information and to explore all MCP server features, be sure to check out the related videos and documentation provided by Microsoft.
Have a great day and enjoy leveraging the new capabilities in Business Central MCP server!
