powerbi-mcp
Verified Safeby sulaiman013
Overview
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.
Installation
python src/server.pyEnvironment Variables
- TENANT_ID
- CLIENT_ID
- CLIENT_SECRET
- LOG_LEVEL
Security Notes
The project integrates a robust security layer for PII detection, audit logging, and access policies, which is a significant positive. However, it relies on environment variables for sensitive cloud credentials (TENANT_ID, CLIENT_ID, CLIENT_SECRET), which is good practice but requires careful management outside the code. The use of 'eval' for .NET assembly loading in connectors, while common for .NET interop, carries inherent risks. Extensive file manipulation for PBIP projects (reading, writing, copying, deleting via `powerbi_pbip_connector.py`) and execution of arbitrary DAX queries means the tool has significant power over the local system and data. The `pbip_load_project` tool directly takes user-provided paths for PBIP projects, which necessitates trust in the input or robust path sanitization to prevent potential traversal vulnerabilities.
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.
metabase-mcp-server
Enables AI assistants to interact with and manage Metabase's analytics platform by providing comprehensive API access through a Model Context Protocol server.
d365fo-client
This server provides a Model Context Protocol (MCP) interface for a D365 F&O client, enabling AI assistants and other MCP-compatible tools to interact with Microsoft Dynamics 365 Finance & Operations environments for metadata retrieval, CRUD operations, action execution, and data querying.