tabular-mcp

tabular-mcp

3.4

If you are the rightful owner of tabular-mcp and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

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

The Tabular MCP Server, also known as MCPBI, facilitates communication between MCP-enabled LLM clients and PowerBI tabular models. It leverages the AdomdConnection in ADOMD.NET to connect to local instances of Tabular models, allowing users to execute DAX queries and retrieve model metadata. This server is particularly useful for debugging, analyzing, and composing DAX queries, providing a robust interface for advanced data analysis. By supporting both predefined metadata queries and flexible DAX queries with full DEFINE block capabilities, the server enhances the analytical capabilities of PowerBI users. It is an essential tool for developers and analysts who need to interact with PowerBI models programmatically, offering a suite of tools for querying, validating, and analyzing data models.

Features

  • Connects to local PowerBI Tabular models using ADOMD.NET.
  • Supports execution of DAX queries and retrieval of model metadata.
  • Facilitates debugging and analysis of DAX queries.
  • Provides tools for listing measures, tables, and relationships.
  • Enables advanced analysis with full DEFINE block capabilities.

Tools

  1. ListMeasures

    List all measures in the model with essential information.

  2. GetMeasureDetails

    Get details for a specific measure by name.

  3. ListTables

    List all tables in the model.

  4. GetTableDetails

    Get details for a specific table by name.

  5. RunQuery

    Execute a DAX query with full DEFINE block capabilities.