MCPBI - Tabular Model

PowerBI MCP server to give LLM clients (Claude, GH Copilot,etc) context from locally running PowerBI Desktop instances.

c#

19

GitHub Stars

c#

Language

6 months ago

First Indexed

2 months ago

Catalog Refreshed

Documentation & install

Readme and setup notes from the catalogue, plus a client-ready config you can copy for your MCP host.

Installation

Add the following to your MCP client configuration file.

Configuration

View docs

{
  "mcpServers": {
    "jonaolden-mcpbi": {
      "command": "path\\\\to\\\\release\\\\mcpbi.exe",
      "args": [
        "--port",
        "YOUR_PBI_PORT"
      ],
      "env": {
        "PBI_PORT": "56751",
        "PBI_DB_ID": "YOUR_DB_ID"
      }
    }
  }
}

Available tools

ListTables

Lists all tables in the model with basic metadata so you can understand the structure.

GetTableColumns

Retrieves columns for a specific table, including data types and keys.

GetTableRelationships

Shows relationships between tables to reveal model navigation paths.

ListMeasures

Lists measures defined in the model to help you study existing calculations.

GetMeasureDetails

Provides detailed metadata for a specific measure, including DAX expression and formatting.

PreviewTableData

Returns a sample of data from a table to inspect actual values.

RunQuery

Executes a custom DAX query against the model and returns results with metadata.

ValidateDaxSyntax

Validates DAX syntax without executing the query and returns errors if any.

AnalyzeQueryPerformance

Analyzes query performance and offers optimization suggestions.

ListFunctions

Lists available DAX functions with category/origin and basic usage notes.

GetFunctionDetails

Provides full details for a specific DAX function, including parameters and return type.