Interact with Power BI Desktop to write DAX, optimize measures, and inspect models.
The available materials indicate an open-source MIT-licensed MCP server with no required secrets and no declared remote endpoints, with no clear high-risk red flags. Its core function still implies local code execution and interaction with local Power BI Desktop, so normal caution is appropriate.
The materials explicitly state that no secrets or environment variables are required. No API tokens, account passwords, or third-party credentials are indicated, so credential exposure and abuse risk appears low.
No remote endpoints are declared, and the materials do not describe sending data to external services. Based on the available information, there is no clear data egress path, though the missing README means the actual implementation should still be verified in source.
The system flags executes-code, and as an MCP tool it must run locally and interact with Power BI Desktop. This is a normal capability for this class of tool; no privilege escalation or suspicious execution beyond the stated purpose is described, but it should still be treated with standard caution as local-execution software.
Its stated functions include model inspection, DAX authoring, and measure optimization, which reasonably implies access to a local Power BI Desktop session or related model data. The materials do not define exact read/write scope, file modification behavior, or access boundaries, so caution is warranted regarding exposure to local analytical data.
Positive factors include being open source, auditable, and MIT licensed. However, it comes from a third-party registry, shows 0 stars, has unknown maintenance status, and lacks a README, leaving limited visible audit context. There are no concrete red flags sufficient for a high-risk rating, but supply-chain trust should be verified further.
Copy the install command and let the AI configure it · recommended for beginners
No copy-paste install info for "powerbi-mcp-server" yet — see the docs or source repo.
Create a DAX measure for the sales table that calculates year-to-date sales up to today, and explain the formula logic.
A ready-to-use DAX measure formula with a brief explanation.
Review this DAX measure for performance issues, provide an optimized version, and explain why it is more efficient: [paste measure formula]
An improved formula, optimization recommendations, and reasoning.
Analyze the current Power BI data model, including table relationships, key fields, and potential modeling issues, then suggest improvements.
A model overview, a list of issues, and actionable improvement suggestions.
Inspect, optimize, and author DAX in Power BI Desktop with natural language.
Manage Power BI workspaces, datasets, and refreshes using natural language.
Analyze PBIX files, use Power BI APIs, and export reports and models.
Connect to Power BI via MCP to inspect models and analyze data.
Control Power BI with natural language to build measures and improve models.
Create, edit, and evaluate Power BI files without Power BI Desktop.