Skip to content

mbrummerstedt/powerbi-analyst-mcp

MCP Developer Tools

A locally‑run server that lets LLMs such as Claude query and analyse Power BI semantic models without sending data to the cloud

Track releases GitHub
Python Latest v0.4.1 · 3mo ago Security brief →

Features

  • Run natural‑language DAX queries against live Power BI models via an LLM
  • Automatically save large result sets to local CSV files and page them on demand
  • Log every query in a JSONL audit trail for reusable patterns and provenance
  • Keep all data, tokens and OAuth credentials on the user’s machine

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 validation — build.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.

View release on GitHub
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
View release on GitHub
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.

View release on GitHub
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
View release on GitHub

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
13
Forks
3
Languages
Python Shell Dockerfile
View on GitHub

Install & Platforms

Install via
pip

Similar tools

sbroenne/mcp-server-excel
EtienneChollet/ontomics
PMB
ahmetsbilgin/finbrain-mcp
VictoriaMetrics-Community/mcp-victoriametrics

Alternative to

Remote Power BI MCP Server Power BI Modeling MCP Server

Beta — feedback welcome: [email protected]