Power Bi Analyst Mcp

Created By

mbrummerstedt9 days 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.

# power-bi

# powerbi

Overview Content Tools Comments

Content

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.

Server Config

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

Recommend Servers

TraeBuild with Free GPT-4.1 & Claude 3.7. Fully MCP-Ready.

Y GuiA web-based graphical interface for AI chat interactions with support for multiple AI models and MCP (Model Context Protocol) servers.

BlenderBlenderMCP connects Blender to Claude AI through the Model Context Protocol (MCP), allowing Claude to directly interact with and control Blender. This integration enables prompt assisted 3D modeling, scene creation, and manipulation.

AiimagemultistyleA Model Context Protocol (MCP) server for image generation and manipulation using fal.ai's Stable Diffusion model.

RedisA Model Context Protocol server that provides access to Redis databases. This server enables LLMs to interact with Redis key-value stores through a set of standardized tools.

WindsurfThe new purpose-built IDE to harness magic

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

Visual Studio Code - Open Source ("Code - OSS")Visual Studio Code

Serper MCP ServerA Serper MCP Server

EdgeOne Pages MCPAn MCP service designed for deploying HTML content to EdgeOne Pages and obtaining an accessible public URL.

CursorThe AI Code Editor