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
License
MIT