Advertise
MCP.so
Sign In
T

Tabular MCP Server

@jonaolden

Repository

Basic information

Category

Other

Transports

stdio

Author

jonaolden

Submitted by

jonaolden

About Tabular MCP Server

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

Tabular MCP Server 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"
      ]
    }
  }
}

Tabular MCP Server tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

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

Frequently asked questions

1

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.

2

How does Tabular Mcp connect to Tabular models?

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

3

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.

4

Is Tabular Mcp an open source alternative to another tool?

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

5

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

More Other MCP servers

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

Sequential Thinking

modelcontextprotocol

Model Context Protocol Servers

88.2K

ICSS

chokcoco

不止于 CSS

20.7K

Handl

Handl speaks the Model Context Protocol. Your whole billing operation — projects, invoices, clients, reports, approvals — as tools any AI assistant can call, inside your autonomy rules.

Health by Dr Brad

Dr Brad Stanfield

Health by Dr Brad works out a health plan from your own results: which screening is due at your age, and evidence-based suggestions, each with the reason and the published guideline or study behind it. Your record is one

Advertise