{"id":"sulaiman013-powerbi-mcp","name":"powerbi-mcp","homepage":null,"repo_url":"https://github.com/sulaiman013/powerbi-mcp","category":"ai-ml","subcategories":[],"tags":["mcp","power-bi","dax","data-analytics","security","pii-masking","model-refactoring","row-level-security","pbip"],"what_it_does":"A Model Context Protocol (MCP) server that lets AI assistants interact with Microsoft Power BI Desktop and Power BI Service to inspect semantic models, run DAX, test Row-Level Security, and perform safe model/report modifications (notably via PBIP file editing for renames).","use_cases":["Natural-language querying of Power BI datasets (execute DAX)","Listing model metadata (tables/columns/measures) for agent-driven exploration","Testing and validating RLS roles during development","Bulk renaming of tables/columns/measures in PBIP projects while updating both semantic model and report bindings to avoid broken visuals","Security-aware auditing of queries and policy-based masking/blocking of sensitive fields"],"not_for":["Using the deprecated TOM-based batch rename tools for renaming (can break report visuals)","Serving as a public API for end users without additional deployment/security hardening","Providing guarantees about exact Power BI internal compatibility across all PBIP formats/versions beyond what the repo docs claim"],"best_when":"You want an MCP-compatible tool that an AI agent can call to explore/query Power BI models and safely apply PBIP-based refactors with PII masking and audit logging.","avoid_when":"You need an official, fully managed Microsoft-supported integration, or you plan to use TOM rename operations instead of PBIP tools for changes to report-bound entities.","alternatives":["Direct Power BI REST/XMLA/TOM tooling with your own integration layer","Other MCP servers or connectors for analytics/model access (if available in your ecosystem)","Manual PBIP editing or internal BI tooling/scripts for refactoring Power BI projects"],"af_score":57.2,"security_score":62.2,"reliability_score":37.5,"package_type":"mcp_server","discovery_source":["github"],"priority":"high","status":"evaluated","version_evaluated":null,"last_evaluated":"2026-03-30T13:46:16.876591+00:00","interface":{"has_rest_api":false,"has_graphql":false,"has_grpc":false,"has_mcp_server":true,"mcp_server_url":null,"has_sdk":false,"sdk_languages":[],"openapi_spec_url":null,"webhooks":false},"auth":{"methods":["Azure AD app registration (for cloud connectivity)"],"oauth":true,"scopes":true,"notes":"Docs reference Azure AD App Registration with Dataset.Read.All and Workspace.Read.All for Power BI Service access; Desktop connectivity implies local connection without a described OAuth flow."},"pricing":{"model":null,"free_tier_exists":false,"free_tier_limits":null,"paid_tiers":[],"requires_credit_card":false,"estimated_workload_costs":null,"notes":"Open-source (MIT) tooling per repository metadata; pricing not applicable."},"requirements":{"requires_signup":false,"requires_credit_card":false,"domain_verification":false,"data_residency":[],"compliance":["GDPR (mentioned in audit logging context)","HIPAA (mentioned in audit logging context)","SOC2 (mentioned in audit logging context)"],"min_contract":null},"agent_readiness":{"af_score":57.2,"security_score":62.2,"reliability_score":37.5,"mcp_server_quality":80.0,"documentation_accuracy":70.0,"error_message_quality":0.0,"error_message_notes":null,"auth_complexity":60.0,"rate_limit_clarity":10.0,"tls_enforcement":70.0,"auth_strength":70.0,"scope_granularity":60.0,"dependency_hygiene":45.0,"secret_handling":60.0,"security_notes":"Docs claim HTTPS-oriented deployment is implied (MCP over local/command execution not fully specified), include PII detection with masking and configurable access policies, and describe query audit logging with policy violation flags. However, repository-level implementation details (TLS enforcement, secure secret storage, dependency scanning/CVE status) are not provided in the supplied content, so scores are conservative.","uptime_documented":0.0,"version_stability":60.0,"breaking_changes_history":40.0,"error_recovery":50.0,"idempotency_support":"false","idempotency_notes":"No explicit idempotency guarantees documented for write/rename operations; PBIP renames likely overwrite/update project artifacts rather than being explicitly idempotent.","pagination_style":"none","retry_guidance_documented":false,"known_agent_gotchas":["TOM-based rename tools are explicitly deprecated and can break report visuals; use PBIP rename tools for tables/columns/measures.","PBIP workflow requires closing Power BI Desktop before editing and reopening afterward.","Cloud connectivity requires appropriate Azure AD permissions and XMLA endpoint enablement; failures may occur if prerequisites are missing.","PBIP repair/diagnostics tools may be needed if renames were performed outside the PBIP tools."]}}