A
licenseNot graded
qualityD
maintenanceBridges the Model Context Protocol to the Tabular Object Model, enabling natural language inspection, optimization, and authoring of DAX in Power BI Desktop.
25
MIT
MCP_powerbi_TS
by Mavline
Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@MCP_powerbi_TSShow me the relationships in the current Power BI model"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
MCP_powerbi_TS
TypeScript MCP (Model Context Protocol) server for Power BI Desktop integration. Connects to a running Power BI Desktop instance through its local Analysis Services (XMLA) endpoint and exposes a set of specialized agents for model work: running DAX queries, inspecting and editing table structure, and managing model relationships.
Layout
src/
index.ts entry point
agents/ 13 specialized agents (DAX, tables, relationships, ...)
server/ MCP server wiring
services/ XMLA / Power BI connection services
types/ shared types
utils/ helpers
tests/ unit and integration tests (synthetic star-schema demo data)Related MCP server: powerbi-mcp-server
Install & build
npm install
npm run build # tsc -> dist/Use with an MCP client
Power BI Desktop must be running with the target model open (the server discovers the local XMLA port).
{
"mcpServers": {
"powerbi": {
"command": "node",
"args": ["<path-to-repo>/dist/index.js"]
}
}
}This server cannot be deployed
Maintenance
ActivityMaintained
ResponsivenessNo issues
Related MCP Connectors
- dataOAuthco.thinair
PostgreSQL, MySQL, and SQL Server in one session. 26 read-only MCP tools for AI agents.
AgentPMT is the AI agent marketplace that turns any MCP-compatible AI assistant into an autonomous employee. Connect once and your agents gain access to a growing ecosystem of tools, workflows, and skills spanning communication, data analytics, development, file management, search, and more. AgentPMT dynamically discovers and orchestrates tools from across the MCP ecosystem, so your agents can independently find the right tool for any task without manual configuration.
Design domain models and generate deterministic multi-stack code, driven by your coding agent.
Create and manage AI agents that collaborate and solve problems through natural language interacti…
Related MCP Servers
- AlicenseNot gradedqualityDmaintenanceEnables natural language interaction with Power BI Desktop via MCP, allowing DAX authoring, measure optimization, and model inspection.MIT
- AlicenseNot gradedqualityCmaintenanceEnables Claude Code to read and modify Power BI data models locally, including searching DAX formulas and editing measures through a direct SSAS connection.MIT
- AlicenseBqualityAmaintenanceEnables AI agents to author and edit Power BI files locally (.pbix/PBIP), covering semantic models, reports, and Power Query M with 490 tools.10023 npm3Cryptographic Autonomy 1.0 (Combined Work Exception)