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.