Back to Home
sulaiman013 icon

powerbi-mcp

Verified Safe

by 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

Run Command
python src/server.py

Environment 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

Stats

Interest Score55
Security Score7
Cost ClassMedium
Avg Tokens500
Stars85
Forks42
Last Update2025-12-01

Tags

Power BIData AnalyticsModel ManagementAI AgentSecurity