{"id":"semantic-model-mcp-server","name":"semantic-model-mcp-server","af_score":44.0,"security_score":57.2,"reliability_score":27.5,"what_it_does":"semantic-model-mcp-server is a Python MCP server that connects to Microsoft Fabric and Power BI semantic models to browse workspaces/datasets, retrieve and validate TMSL, execute DAX queries, and create/update models via TMSL. It also includes a Best Practice Analyzer (BPA) that evaluates TMSL against a set of industry/Microsoft-recommended rules, plus tooling for detecting and using local Power BI Desktop instances for development/testing.","best_when":"You are already working with Microsoft Fabric/Power BI semantic models and want MCP-driven tooling plus a TMSL/BPA workflow, including optional local Power BI Desktop validation.","avoid_when":"You cannot reliably provide Azure AD authentication/permissions or you need rigorous API contracts (OpenAPI/structured error codes) and operational guarantees (idempotency, pagination, retry guidance).","last_evaluated":"2026-04-04T21:44:53.361628+00:00","has_mcp":true,"has_api":false,"auth_methods":["Microsoft authentication (Azure AD) for Fabric/Power BI access (implied by prerequisites and dependency on msal/azure-identity)"],"has_free_tier":false,"known_gotchas":["Write operations (create/update semantic models) could have side effects if the agent mis-specifies TMSL; guardrails/validation are not documented in the provided README.","Local Power BI Desktop detection relies on running processes/ports; behavior may vary across machines and can be timing-sensitive.","No explicit guidance is provided for safe retries of DAX execution/model updates."],"error_quality":0.0}