jonaolden/mcpbi
If you are the rightful owner of mcpbi 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.
Tools
Functions exposed to the LLM to take actions
ListTables
Lists all tables in your model with metadata.
GetTableDetails
Retrieves detailed metadata for a specific table.
GetTableColumns
Lists all columns in a table with data types and properties.
GetTableRelationships
Shows all relationships connected to a table.
ListMeasures
Lists all measures with names, tables, and data types.
GetMeasureDetails
Retrieves complete measure definition including full DAX expression.
PreviewTableData
Returns top N rows from a table.
RunQuery
Executes DAX queries and returns structured results.
ValidateDaxSyntax
Validates DAX expressions and provides complexity metrics.
AnalyzeQueryPerformance
Analyzes query execution time and performance characteristics.
Prompts
Interactive templates invoked by user choice
No prompts
Resources
Contextual data attached and managed by the client