mcpbi
Verified Safeby jonaolden
Overview
Provides a Model Context Protocol (MCP) server for local Power BI Tabular Models, enabling LLM clients to interact for debugging, analysis, and DAX query composition.
Installation
dotnet run --project pbi-local-mcp/pbi-local-mcp.csprojEnvironment Variables
- PBI_PORT
- PBI_DB_ID
- PBI_OBFUSCATION_STRATEGY
- PBI_ENCRYPTION_KEY
- DOTNET_LOG_LEVEL
Security Notes
The server explicitly states it only accepts connections from localhost, significantly reducing network attack surface. It performs DAX query validation to prevent malicious queries. Encryption keys (for obfuscation/decryption) are handled via environment variables or command-line parameters, not hardcoded. The project utilizes strong cryptographic algorithms (AES-256, PBKDF2) for its decryption tool. Connection to the Power BI model is read-only. Overall, good security practices are highlighted and seem to be implemented for its intended use case.
Similar Servers
dbt-mcp
Provides AI agents with tools to interact with dbt Core, dbt Fusion, and dbt Platform, enabling advanced data analytics and project management capabilities within a model context protocol (MCP) server.
airtable-mcp-server
The server enables LLMs to inspect Airtable database schemas, then read and write records, providing comprehensive data management capabilities.
powerbi-modeling-mcp
Automate Power BI semantic model development and management using AI agents via the MCP protocol.
PowerBI-Desktop-MCP
Enables AI assistants to programmatically interact with Power BI Desktop models for data exploration, analysis, and modification.