MCP Connection Specialist/bi-connect

Wire the agent to Power BI Desktop via the official MCP.

The connection specialist. Sets up powerbi-modeling-mcp and microsoft-learn at the user level for Claude Code, Copilot, Codex, Gemini, or Kilo, and authors DAX user-defined functions with DAXLIB awareness.

Get startedView on GitHub

What it does

  • Routes between local Modeling MCP setup, agent config check, and local plugin verification.
  • Guides super install --all --yes or super install --agent <id> --yes per agent.
  • Verifies the right config file per agent (~/.claude.json, ~/.codex/config.toml, etc.).
  • Sets BI_SUPERPOWERS_POWERBI_MODELING_MCP_PATH for manual installs.
  • Authors DAX UDFs with namespacing, VAL vs EXPR parameter hints, and INFO.USERDEFINEDFUNCTIONS validation.
  • Adapts DAXLIB patterns with attribution instead of vendoring whole packages.
  • Saves Desktop before any taskkill so MCP edits don't vanish.

When to use

  • Power BI Desktop is open but the agent doesn't see the model.
  • You're setting up bi-superpowers on a new machine or a new agent.
  • You want to write DAX UDFs and you need DAXLIB-aware guidance.
  • The MCP edits seemed to land but the .pbip on disk shows nothing changed.

Example prompts

/bi-connect
Just installed bi-superpowers on Codex. Wire up Power BI Modeling MCP and Microsoft Learn from scratch.
/bi-connect
Write a Company.Sales.GrossMarginPct DAX UDF and persist it through the Modeling MCP, validating with INFO.USERDEFINEDFUNCTIONS.

How it works

  1. 01

    Triage the request (connect, verify config, verify local plugin).

  2. 02

    Confirm Windows + Power BI Desktop and the Modeling MCP extension.

  3. 03

    Run super install --agent <id> --yes and restart the agent.

  4. 04

    Verify powerbi-modeling-mcp and microsoft-learn are present in the agent's config.

  5. 05

    For UDFs, inspect existing functions, draft with DEFINE FUNCTION, and persist via MCP.

  6. 06

    Save before any taskkill (helper or Ctrl+S).

Connects to

/bi-start

Returns control to the session orchestrator once the connection is healthy.

Skills →/bi-kickoff

Hand back to project bootstrap when the user is starting a new project.

Skills →/bi-dax

After UDF authoring, hand off to DAX work that uses the new functions.

Skills →

Ready to use /bi-connect?

Install bi-superpowers and your agent gets this skill (and the other five) in one command.

Get started← Back to all skills