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

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.

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.

Tavily Mcp

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

Serper MCP ServerA Serper MCP Server

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

ChatWiseThe second fastest AI chatbot™

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

DeepChatYour AI Partner on Desktop

Zhipu Web SearchZhipu Web Search MCP Server is a search engine specifically designed for large models. It integrates four search engines, allowing users to flexibly compare and switch between them. Building upon the web crawling and ranking capabilities of traditional search engines, it enhances intent recognition capabilities, returning results more suitable for large model processing (such as webpage titles, URLs, summaries, site names, site icons, etc.). This helps AI applications achieve "dynamic knowledge acquisition" and "precise scenario adaptation" capabilities.

Baidu Map百度地图核心API现已全面兼容MCP协议，是国内首家兼容MCP协议的地图服务商。

MiniMax MCPOfficial MiniMax Model Context Protocol (MCP) server that enables interaction with powerful Text to Speech, image generation and video generation APIs.