MCP Engine Public, also known as SemanticOps MCP, is a free MCP server developed by Maxanatsko. It enables programmatic interaction with Power BI models and Power BI Desktop files. Designed for Power BI developers and analysts, this tool connects AI assistants like Claude, Copilot, and ChatGPT to your semantic models. It supports various operations, from reading model structures to modifying them and running DAX queries, enhancing Power BI development workflows through AI capabilities.

What does MCP Engine Public connect to?

MCP Engine Public, also known as SemanticOps MCP, functions as an MCP server. It establishes programmatic connections and interactions with Power BI models and Power BI Desktop files. This tool is designed to bridge AI assistants with your Power BI environment, allowing for advanced operations on your data models. It supports both local servers using stdio transport and remote servers utilizing Streamable HTTP protocols, ensuring adaptable deployment options for various Power BI development needs.

Core features and tools

While specific callable tool names are not detailed, MCP Engine Public empowers AI assistants to perform several key actions. These include reading Power BI model structures, running DAX queries, and modifying semantic models. It also enables advanced analytics and the generation of model documentation. The tool's capabilities allow for creating DAX measures, managing relationships, and optimizing performance within Power BI models through AI-driven commands.

Who is it for?

MCP Engine Public is intended for Power BI developers and analysts who aim to integrate AI assistants into their Power BI development processes. It helps automate tasks such as model structure analysis, DAX query execution, and semantic model modifications. This tool is particularly useful for those seeking to enhance productivity and precision in managing Power BI assets with the aid of AI. Skip this if you do not work with Power BI models or AI assistants.

How to get started

Access is granted through a standard OAuth authorization flow for remote servers using Streamable HTTP, with access tokens attached to each request. Public MCP servers may also use Google OAuth or API keys (Bearer token in the header). For local STDIO transport servers, authentication can utilize environment variables or system credentials.

Use cases

• Reading Power BI model structures.
• Running DAX queries against Power BI models.
• Modifying semantic models, including creating DAX measures and managing relationships.
• Performing advanced analytics and generating model documentation.

MCP Engine Public by Maxanatsko offers a powerful way for Power BI professionals to connect AI assistants to their data models. It supports essential development tasks like reading model structures, executing DAX, and modifying semantic models. The tool's compatibility with major AI clients and flexible authentication options make it a valuable addition for AI-driven Power BI development.