Tabular Mcp

@jonaolden

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

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.

Is Tabular Mcp an open source alternative to another tool?

Yes, it is described as an open source alternative to PowerBI Copilot.

What transport does Tabular Mcp use?

It is configured as a stdio MCP server in Visual Studio Code via a .vscode/mcp.json file.

Frequently asked questions

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.

Is Tabular Mcp an open source alternative to another tool?

Yes, it is described as an open source alternative to PowerBI Copilot.

What transport does Tabular Mcp use?

It is configured as a stdio MCP server in Visual Studio Code via a `.vscode/mcp.json` file.

Comments

Basic information

More Other MCP servers

MCP Toolbox for Databases

googleapis

MCP Toolbox for Databases is an open source MCP server for databases.

15.9K

Reactive Resume

amruthpillai

A one-of-a-kind resume builder that keeps your privacy in mind. Completely secure, customizable, portable, open-source and free forever. Try it out today!

39.5K