Skip to content

mbrummerstedt/powerbi-analyst-mcp

MCP Developer Tools

A local server that lets LLMs like Claude query Power BI semantic models directly, turning natural‑language requests into live DAX results while keeping all data on the user's machine.

Python Latest v0.4.1 · 1mo ago Security brief →

Features

  • Run natural‑language analytics against live Power BI models via LLMs (e.g., Claude).
  • Automatically save large query results to local CSV and page them on demand, preserving context window limits.
  • Log every DAX query and result for audit trails and reusable patterns across sessions.
  • Authenticates with Power BI using the OAuth device‑code flow; all data stays on the user's computer.

Recent releases

View all 4 releases →
v0.4.1 Mixed
⚠ Upgrade required
  • Build-time validation in `build.sh` will fail if `manifest.json` tools do not match registered code tools
  • `CLAUDE.md` added documenting bundle rules for future development
Notable features
  • `list_apps` becomes the default discovery path with updated tool descriptions
  • 403 error handling in `execute_dax` now gives an actionable message about missing Build permission
Full changelog

What's changed

  • list_apps is now the default discovery path — tool descriptions updated to guide the LLM toward apps first, list_workspaces demoted to fallback
  • 403 error handling in execute_dax — actionable message when Build permission is missing, pointing users to check their app access
  • Build-time tool validationbuild.sh now fails if manifest.json tools don't match registered tools in code
  • CLAUDE.md added — documents bundle rules for future development

Installation

The .mcpb bundle is distributed internally. Contact your admin for the latest bundle file.

v0.1.2 New feature
Notable features
  • Add `glama.json` for Glama MCP directory listing
  • Add Glama badge to README
  • Add Dockerfile for containerized deployment
Full changelog

Changes

  • Defer MSAL authentication to first tool call — server now boots with placeholder credentials (enables Glama server inspection)
  • Add glama.json for Glama MCP directory listing
  • Add Glama badge to README
  • Add Dockerfile for containerized deployment
v0.1.1 Feature
Notable features
  • Include MCP Registry ownership tag in published README
Changelog

Include MCP Registry ownership tag in published README for registry validation.

v0.1.0 Feature
Notable features
  • OAuth device code authentication with OS‑native token caching
  • Browse Power BI workspaces, datasets, tables, measures, and columns
  • Execute DAX queries with automatic large‑result CSV handling
Full changelog

Initial release of Power BI Analyst MCP.

  • OAuth device code authentication with OS-native token caching
  • Browse workspaces, datasets, tables, measures, and columns
  • Execute DAX queries with automatic large-result CSV handling
  • Paged CSV reading to protect LLM context windows
  • JSONL query history with search and delete for cross-session reuse

Weekly OSS security release digest.

The CVE patches and breaking changes that affected production tools this week. One email, every Sunday.

No spam, unsubscribe anytime.

About

Stars
11
Forks
3
Languages
Python Shell Dockerfile

Install & Platforms

Install via
pip

Alternative to

Remote MCP (Power BI) Modeling MCP (Power BI)

Beta — feedback welcome: [email protected]