Forum Discussion

gchik's avatar
gchik
Regular Visitor
30 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
    30 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.

Natarajan_M's avatar
Natarajan_M
Super User
28 days ago

Hi gchik , Currently we cant add claude as a plugin and do the analysis . 

The alternate approach would be use the pbi reportinh skills + PBI mcp server from microsoft and connect the pbi file to the claude code and run your analysis . 

PBI MCP : https://learn.microsoft.com/en-us/power-bi/developer/mcp/remote-mcp-server-get-started

PBI Skills :https://learn.microsoft.com/en-us/power-bi/developer/agentic/power-bi-report-authoring-skill-overview


Thanks!

Natarajan Manivasagan

If you found this helpful, please consider giving it a Kudos and marking it as the accepted solution — it goes a long way in helping others facing the same issue.

 

🏆 Best Solution for Enterprise BI — 2026 Microsoft Fabric Semantic Link Developer Experience Challenge
👉 Microsoft announcement · View the winning notebook

 

For more Power BI tips and discussions, let's connect on LinkedIn.

 

Cheers!