home / mcp / mcpbi - tabular model mcp server
PowerBI MCP server to give LLM clients (Claude, GH Copilot,etc) context from locally running PowerBI Desktop instances.
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"
}
}
}
}Lists all tables in the model with basic metadata so you can understand the structure.
Retrieves columns for a specific table, including data types and keys.
Shows relationships between tables to reveal model navigation paths.
Lists measures defined in the model to help you study existing calculations.
Provides detailed metadata for a specific measure, including DAX expression and formatting.
Returns a sample of data from a table to inspect actual values.
Executes a custom DAX query against the model and returns results with metadata.
Validates DAX syntax without executing the query and returns errors if any.
Analyzes query performance and offers optimization suggestions.
Lists available DAX functions with category/origin and basic usage notes.
Provides full details for a specific DAX function, including parameters and return type.