powerbi-service-mcp-server
by HDieter6789
Overview
Provides a Micro-Context Protocol (MCP) server and HTTP API for automating Power BI operations, including REST API interactions and local PBIX/PBIT file transformations.
Installation
docker compose up -dEnvironment Variables
- CLIENT_ID
- TENANT_ID
- API_KEY
- PBI_AUTH_MODE
- CLIENT_SECRET
- PBI_TOOLS_PATH
- PORT
- PBI_SCOPE
- CORS_ORIGINS
- NODE_ENV
- LOG_LEVEL
- WORKDIR
Security Notes
CRITICAL: The server uses 'child_process.spawn' with 'shell: true' to execute 'pbi-tools'. User-controlled inputs for file paths (e.g., 'filePath', 'outDir', 'projectDir', 'outPath') are passed directly to these commands. This creates a severe command injection vulnerability if a malicious path containing shell commands is provided, potentially allowing arbitrary code execution on the host system. Additionally, the default CORS_ORIGINS is '*' which is risky for public deployments, and API key authentication uses a single shared key, which requires careful management.
Similar Servers
powerbi-modeling-mcp
Connects AI agents to Power BI semantic models to enable natural language interaction for building, modifying, and managing data models.
PowerBI-Desktop-MCP
Enables AI assistants to programmatically interact with Power BI Desktop models for data exploration, analysis, and modification.
powerbi-mcp
Enables AI assistants to interact with Power BI Desktop and Service for querying data, managing models, and performing safe bulk operations through natural language, ensuring enterprise-grade security and preserving report visual integrity during refactoring.
mcpbi
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.