Power Bi Analyst Mcp

Created By

mbrummerstedt4 months ago

Connect Claude to your Power BI semantic models. Browse workspaces, tables, and measures, run DAX queries, and get results — with large datasets automatically saved to local CSV files to protect the LLM context window. Includes a query history log for cross-session reuse and auditability.

Overview Content Tools Comments

Overview

What it does

Ask your LLM to analyse Power BI data. The server connects to Power BI's REST API via OAuth device code flow, lets the agent explore your semantic models, and execute DAX queries — all running locally on your machine.

Key features

12 tools — authenticate, browse workspaces/datasets/tables/measures/columns, execute DAX, page through results, search query history, delete log entries
Large result handling — queries returning >50 rows are auto-saved to a local CSV; the agent gets a compact summary and pages on demand
Query history — every DAX execution is logged to a JSONL file with the user's intent, DAX, columns, and CSV path — searchable across sessions
Secure — runs locally, tokens stored in OS-native secure storage (Keychain/DPAPI/LibSecret), no cloud relay

Quick start

Requires an Azure AD app registration with Dataset.Read.All and Workspace.Read.All permissions. See the README for a 5-minute setup guide.

Try in Playground

Server Config

{
  "mcpServers": {
    "powerbi": {
      "command": "uvx",
      "args": [
        "powerbi-analyst-mcp"
      ],
      "env": {
        "POWERBI_CLIENT_ID": "<YOUR_CLIENT_ID>",
        "POWERBI_TENANT_ID": "<YOUR_TENANT_ID>"
      }
    }
  }
}

Project Info

Created At

4 months ago

Updated At

4 months ago

Author Name

mbrummerstedt

Star

-

Language

-

License

-

Category

Tags

Homepage

https://github.com/mbrummerstedt/powerbi-analyst-mcp

Recommend Servers

Kazakhstan Payments Mcp

@junter1989k-ai

11 days ago

Poland Payments Mcp

@junter1989k-ai

11 days ago

Mcp Server Chatsum

summarize chat message

typescript

a year ago

Jina AI MCP Tools

A Model Context Protocol (MCP) server that integrates with Jina AI Search Foundation APIs.

JavaScript

a year ago

Jordan Payments Mcp

@junter1989k-ai

11 days ago

Czechia Payments Mcp

@junter1989k-ai

11 days ago

@modelcontextprotocol

Location services, directions, and place details

a year ago

Songcheck Ai Music Detector

@afghanfansmedia-ai

Is this song AI or human? SongCheck detects AI-generated music (Suno, Udio, and more) and media from any AI agent. Point it at an audio file, an image/video, or a whole music folder and it returns a verdict (LIKELY AI-GENERATED / UNCERTAIN / LIKELY HUMAN), an AI-probability score, confidence, and provenance signals (Content Credentials / SynthID watermark, generator hints). Tools: detect_ai_music, detect_ai_media, scan_catalog (audit an entire catalog), and songcheck_health. Free tier is 5 checks/day; a paid key unlocks unlimited catalog scans. Powered by SongCheck (Khaled Media), a self-hosted v9 ensemble detector.

6 days ago

Croatia Payments Mcp

@junter1989k-ai

11 days ago

AgentQL MCP Server

Model Context Protocol server that integrates AgentQL's data extraction capabilities.

JavaScript

a year ago

One API for Search, Crawling, and Sitemaps

a year ago

Language models generate; Concordance verifies. The verify tool checks a claim deterministically (no model in the loop) and returns HOLDS / BROKEN / INCOMPLETE with the worked reasoning and a sealed receipt (content_hash + cite_url) that re-fetches byte-identical or not at all. Also: ranked search over an ~11k-record library, seal_fetch to re-verify any receipt, redact to strip PII before text travels, and a sealed connection graph. Runs sovereign/offline too (stdlib-first Python). A public false-positive benchmark covers every domain: the engine has never sealed a falsehood. 38 tools live; remote endpoint at https://narrowhighway.com/mcp.

11 days ago

Hong Kong Payments Mcp

@junter1989k-ai

11 days ago

@Henning Witzel-Acikgöz

Host the HTML or Markdown pages your AI generates and share each as a link with comments, versioning, and access control. Create, update, and organize pages and read reviewer comments over MCP.

11 days ago

Italy Payments Mcp

@junter1989k-ai

11 days ago

VC follow intelligence for AI agents. Track what top investors follow on X — detect new follows, convergence signals, and trending companies before they're announced.

5 days ago

@modelcontextprotocol

AI image generation using various models

a year ago

Estonia Payments Mcp

@junter1989k-ai

11 days ago

New Zealand Payments Mcp

@junter1989k-ai

11 days ago

Arcgis Portal Mcp

MCP server for ArcGIS Portal and ArcGIS Online. Lets AI assistants search content, query feature layers, manage features, handle content operations, and administer users and groups. Built on the Model Context Protocol for integration with Claude Desktop, Cursor, VS Code Copilot, and other MCP clients. Disclaimer: This is an independent open-source project. It is not affiliated with, endorsed by, or sponsored by Esri Inc. "ArcGIS" is a registered trademark of Esri.

11 days ago

Firecrawl Mcp Server

Official Firecrawl MCP Server - Adds powerful web scraping to Cursor, Claude and any other LLM clients.

JavaScript

a year ago

@modelcontextprotocol

GitLab API, enabling project management

a year ago

Costa Rica Payments Mcp

@junter1989k-ai

11 days ago

Oman Payments Mcp

@junter1989k-ai

11 days ago

Germany Payments Mcp

@junter1989k-ai

11 days ago

Ghana Payments Mcp

@junter1989k-ai

11 days ago

Switzerland Payments Mcp

@junter1989k-ai

11 days ago

Egypt Payments Mcp

@junter1989k-ai

11 days ago

Australia Payments Mcp

@junter1989k-ai

11 days ago

Slovakia Payments Mcp

@junter1989k-ai

11 days ago