Tabular Mcp
@jonaolden
About Tabular Mcp
MCP server for locally running Tabular Models, i.e. PowerBI models running on PowerBI Desktop.
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.
Basic information
More Other MCP servers
ICSS
chokcoco不止于 CSS
IDA Pro MCP
mrexodiaAI-powered reverse engineering assistant that bridges IDA Pro with language models through MCP.
DeepMark
DeepMark helps teachers deliver rapid, consistent marking with meaningful feedback for every student — in a fraction of the time. What once took a week, now takes one free period.
Sequential Thinking
modelcontextprotocolModel Context Protocol Servers
MCP Go 🚀
mark3labsA Go implementation of the Model Context Protocol (MCP), enabling seamless integration between LLM applications and external data sources and tools.
Comments