Tabular MCP

🚀 Tabular MCP Server AKA MCPBI

A Model Context Protocol (MCP) server for locally running Tabular Models, such as PowerBI models on PowerBI Desktop. It enables MCP - enabled LLM clients to interact with tabular models for debugging, analysis, and DAX query composition.

🚀 Quick Start

This Tabular MCP Server allows MCP - enabled LLM clients to communicate with your local tabular models. It helps you debug, analyze, and compose DAX queries. For example, Copilot can query Tabular Models via MCP.

✨ Features

How it works

It connects to a local running instance of Tabular models using the AdomdConnection in ADOMD.NET. Through this connection, clients can execute DAX - queries and retrieve model metadata (using DMV queries) via pre - defined tools for high accuracy, or use custom DAX queries for debugging and development. This MCP server enables communication between clients and Power BI tabular models via ADOMD.NET, supporting both predefined metadata queries and flexible DAX queries with full DEFINE block capabilities for advanced analysis.

Tools

• ListMeasures: List all measures in the model with essential information (name, table, data type, visibility), optionally filtered by table name. Use GetMeasureDetails for full DAX expressions.
• GetMeasureDetails: Get details for a specific measure by name.
• ListTables: List all tables in the model.
• GetTableDetails: Get details for a specific table by name.
• GetTableColumns: Get columns for a specific table by name.
• GetTableRelationships: Get relationships for a specific table by name.
• PreviewTableData: Preview data from a table (top N rows).
• RunQuery: Execute a DAX query. Supports complete DAX queries with DEFINE blocks, EVALUATE statements, or simple expressions.
• ValidateDaxSyntax: Validate DAX syntax and identify potential issues with enhanced error analysis.
• AnalyzeQueryPerformance: Analyze query performance characteristics and identify potential bottlenecks.

📦 Installation

See for requirements and installation instructions.

Quick Start a) with Pre - built Executables

For the fastest setup, you can use the pre - built executable from the Releases section.

1. Configure Power BI Connection:

   Releases\pbi-local-mcp.DiscoverCli.exe
   

   Follow the prompts to detect your Power BI instance and create the .env file.
2. Configure VS Code MCP Integration: Configure mcp.json with:

{ "mcpServers": { "MCPBI": { "command": "C:\dir\to\mcpbi.exe", "args": [] } } }

### Quick Start b) with port as argument
Or if you already know which port you are running PowerBI Tabular model on (visible from Tabular Editor for instance), configure `mcp.json` with:
```json
{
 "mcpServers": {
   "MCPBI": {
     "command": "C:\\dir\\to\\mcpbi.exe",
     "args": ["--port","12345"]
   }
 }
}

💻 Usage Examples

There are no specific code examples provided in the original README. If you need to execute DAX queries, you can use the RunQuery tool. For example, you can run a simple DAX query like this:

EVALUATE VALUES('Table'[Column])

📚 Documentation

For more detailed information about installation, please refer to . For testing - related content, see .

📄 License

This project is licensed under the MIT license.