Tabular Mcp

Name: Tabular Mcp
Author: jonaolden

@jonaolden

代码仓库

关于 Tabular Mcp

MCP server for locally running Tabular Models, i.e. PowerBI models running on PowerBI Desktop.

#powerbi #power-bi #pbi #analysisservices #analysis-services #dax #dax-query

基本信息

分类

其他

传输方式

stdio

发布者

jonaolden

提交者

jonaolden

配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "tabular-mcp": {
      "type": "stdio",
      "command": "dotnet",
      "envFile": "${workspaceFolder}/.env",
      "args": [
        "run",
        "--project",
        "${workspaceFolder}/pbi-local-mcp/pbi-local-mcp.csproj"
      ]
    }
  }
}

工具

未检测到工具

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

What is Tabular Mcp?

Tabular Mcp is an open source alternative to PowerBI Copilot that connects to a local running instance of Tabular models using the AdomdConnection in ADOMD.NET. It lets users debug and adjust DAX queries and measures using an LLM with full model context, and quickly understand how a model is set up and identify bottlenecks.

How to use Tabular Mcp?

Clone the repository and run dotnet run --project pbi-local-mcp/pbi-local-mcp.csproj discover-pbi to detect Power BI Desktop and populate the .env file with PBI_PORT and PBI_DB_ID. Then configure an MCP server in Visual Studio Code by adding a .vscode/mcp.json file that points to the project with the dotnet run command and references the .env file.

Key features of Tabular Mcp

Execute DAX queries to retrieve model metadata
Pre-defined, well-documented tools for high accuracy
Custom DAX queries for debugging and development
Open source alternative to PowerBI Copilot
Full model context for LLM-driven analysis

Use cases of Tabular Mcp

Debug and adjust DAX queries and measures with an LLM
Quickly understand a model’s structure and find bottlenecks
Develop and test custom DAX queries on local Tabular models

FAQ from Tabular Mcp

What are the system requirements for Tabular Mcp?

.NET 8.0 SDK, Power BI Desktop (with a PBIX file open), Windows OS, and Visual Studio Code for MCP server integration.

How does Tabular Mcp connect to Tabular models?

It connects to a local running instance of Tabular models using the AdomdConnection in ADOMD.NET.

What can Tabular Mcp do with a model?

It can execute DAX queries to retrieve model metadata via DAX INFO functions through pre-defined tools, and also run custom DAX queries for debugging and development.