powerbihelper

AI-powered Power BI report generator. Chat with Ollama or Claude to build reports, test visuals, and analyze data.

Install

pip install powerbihelper

Quick Start

powerbihelper              # opens browser chat UI

Configure your LLM (Ollama or Claude) in the sidebar, then chat:

• "Build a monthly sales dashboard with 4 KPI cards and trend charts"
• "Create an airline reliability report with PIREP analysis by ATA chapter"
• "Validate the report project at ./MyProject"

Features

• Browser Chat UI — talk to Ollama/Claude to build Power BI reports
• PBIP Project Generator — create complete projects from scratch (no Desktop needed)
• PBIR/TMDL Library — read, write, validate report and model files
• Visual Testing — headless Playwright-based testing with regression detection
• DAX Execution — query live Power BI Desktop models
• MCP Server — integrate with Claude Code (13 tools)
• Data Quality — null rates, duplicates, referential integrity checks
• Model Documentation — auto-generate data dictionary and measure catalog

CLI Commands

powerbihelper                    # browser chat UI (default)
powerbihelper ui                 # same as above
powerbihelper agent              # terminal chat with Ollama
powerbihelper generate "prompt"  # one-shot report generation
powerbihelper serve              # MCP server for Claude Code
powerbihelper dax "EVALUATE X"   # run DAX query
powerbihelper pbir read ./proj   # parse PBIP project
powerbihelper pbir validate .    # validate structure
powerbihelper tmdl ./model.tmdl  # parse TMDL file
powerbihelper test --visual x.js # headless visual testing
powerbihelper cdp status         # check Desktop CDP bridge

Use with Claude Code

Add to ~/.claude/settings.json:

{
  "mcpServers": {
    "powerbihelper": {
      "command": "powerbihelper",
      "args": ["serve"]
    }
  }
}

Use with Ollama

ollama pull gemma4
powerbihelper agent --model gemma4

Optional Extras

pip install powerbihelper[mcp]      # Claude Code MCP server
pip install powerbihelper[testing]  # Playwright visual testing
pip install powerbihelper[all]      # everything

License

MIT