Forum Discussion

gchik's avatar
gchik
Regular Visitor
29 days ago
Solved

Connect Claude Code to Power BI Desktop

Hello, I tried to connect Claude Code to Power BI Desktop and have identified some unused columns, measures and would like to remove such.  But Claude didn't have the ability to remove such in Power ...
Need Help
  • Kagiyama_yutaka's avatar
    Kagiyama_yutaka
    29 days ago

    Power BI Desktop doesn’t have an add‑in model like Excel or Word, so there’s no way to install Claude into the UI. Claude can talk to Desktop through Microsoft’s Modeling MCP Server, though, and that gives it access to the semantic model — reading it, generating measures, tweaking existing ones. Whether it can actually delete columns or measures depends on whether the MCP endpoint is writable. A lot of setups are still read‑only, so you end up doing the cleanup manually in Model view.

krishnakanth240's avatar
krishnakanth240
Super User
28 days ago

Hi gchik 
Power BI Desktop does not have Claude add-in like Word or Excel. To get write access you need Power BI Modeling MCP Server installed as a VS Code extension where it connects to your model via the Analysis Services or XMLA endpoint then you point Claude Desktop's MCP configuration at the installed server's `.exe` path and restart.

 

https://www.linkedin.com/posts/datataleau_powerbi-dax-ai-activity-7397406055519088640-RITb

http://databear.com/claude-power-bi-mcp-integration/

https://medium.com/data-science-collective/i-connected-claude-to-power-bi-using-the-pbi-mcp-extension-here-are-the-dashboards-i-built-638f2088a1d9

https://github.com/DheerajKumar97/Power-BI-Custom-MCP-Server-with-Python--Claude-AI-Integration