Tabular Mcp

Name: Tabular Mcp
Author: jonaolden

@jonaolden

Repository

About 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

Basic information

Config

Add this server to your MCP-compatible client using the configuration below.

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

Tools

No tools detected

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

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.