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
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.
d365fo-client
Provides a Model Context Protocol (MCP) server for Microsoft Dynamics 365 Finance & Operations, enabling AI agents and other MCP-compatible tools to perform metadata management, CRUD operations, action calls, label resolution, and environment monitoring.
metabase-mcp-server
Provides AI assistants with programmatic access to Metabase's analytics platform, enabling data querying, dashboard management, and content organization.