Tabular MCP Server

This is a Model Context Protocol (MCP) server for locally running Tabular Models, i.e. PowerBI models running on PowerBI Desktop.

This server allows any MCP-enabled LLM Client to communicate with your tabular models and help you debug, analyse and compose DAX queries.

How it works

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

Using this connection, the server then allows clients to execute DAX-queries to retrieve model metadata (using DAX INFO functions) through pre-defined and well documented tools for high accuracy, as well as 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, optionally filtered by table name

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

How to install

See docs/Installation.md for requirements and installation instructions.

Testing

See resources/testing.md

License

MIT