Power Bi Mcp Server

Created By
michaelmckinleyconsulting7 months ago
A Model Context Protocol (MCP) server that enables AI assistants to interact with Power BI workspaces, datasets, reports, and dashboards programmatically. 🚀 Features Workspace Management: List and manage Power BI workspaces Report Operations: Access, clone, export, and rebind reports Dataset Management: Execute DAX queries, refresh datasets, manage schedules Dashboard Access: List and interact with dashboards Push Datasets: Create and manage push datasets with real-time data Authentication: Secure OAuth2 authentication with Microsoft Entra ID 📋 Prerequisites Node.js (v18 or higher) npm or yarn Power BI Pro or Premium license Microsoft Entra ID app registration MCP-compatible AI assistant (Claude Desktop, etc.)
Overview

What is Power BI MCP Server?

Power BI MCP Server is a Model Context Protocol (MCP) server that allows AI assistants to programmatically interact with Power BI workspaces, datasets, reports, and dashboards.

How to use Power BI MCP Server?

To use the Power BI MCP Server, clone the repository, install the dependencies, and configure the Microsoft Entra ID for authentication. Once set up, your AI assistant can perform various operations on Power BI.

Key features of Power BI MCP Server?

  • Workspace Management: List and manage Power BI workspaces.
  • Report Operations: Access, clone, export, and rebind reports.
  • Dataset Management: Execute DAX queries, refresh datasets, and manage schedules.
  • Dashboard Access: List and interact with dashboards.
  • Push Datasets: Create and manage push datasets with real-time data.
  • Authentication: Secure OAuth2 authentication with Microsoft Entra ID.

Use cases of Power BI MCP Server?

  1. Automating report generation and distribution.
  2. Managing datasets and executing complex DAX queries.
  3. Integrating Power BI functionalities into AI-driven applications.

FAQ from Power BI MCP Server?

  • What are the prerequisites for using Power BI MCP Server?

You need Node.js (v18 or higher), npm or yarn, a Power BI Pro or Premium license, and a Microsoft Entra ID app registration.

  • Is there a cost associated with using Power BI MCP Server?

The server is free for personal, educational, and internal company use, but requires a commercial license for commercial use.

  • What kind of operations can I perform with this server?

You can list workspaces, execute DAX queries, export reports, refresh datasets, and manage push datasets.

Server Config

{
  "mcpServers": {
    "powerbi-mcp-server": {
      "command": "node",
      "args": [
        "path/to/powerbi-mcp-server/dist/index.js"
      ],
      "env": {
        "PBI_PUBLIC_CLIENT_ID": "your_client_id",
        "PBI_TENANT_ID": "your_tenant_id"
      }
    }
  }
}
Project Info
Created At
7 months ago
Updated At
6 months ago
Author Name
michaelmckinleyconsulting
Star
-
Language
-
License
-

Recommend Servers

View All
Bring your real authenticated browser session to AI coding agents. Local-first MCP server + Chrome MV3 extension. No cloud. No telemetry.
@Cubenest

peek records the user's actual logged-in browser (DOM via rrweb, console events, network metadata, optional response bodies via opt-in Deep capture) through a Chrome MV3 extension. The extension ships events through a native-messaging stdio bridge to a local MCP server (peek-mcp), which persists them to a SQLite database at ~/.peek/sessions.db. AI coding agents (Claude Code, Cursor, Cline, Windsurf) read sessions from the database via 10 MCP tools: Tool What it does list_recent_sessions List recently recorded sessions (id, origin, ts, event count). get_session_summary LLM-readable narrative summary of a session. get_session_console_errors Console errors recorded in a session. get_session_network_errors Failed/notable network requests in a session. get_user_action_before_error Last N user actions before a console error. generate_playwright_repro Generate a runnable Playwright test from a session. get_dom_snapshot Reconstruct the DOM at a given timestamp. query_dom_history Timeline of attribute/text changes for a selector. request_authorization Side-panel consent for write actions (Level 3). execute_action Dispatch a UI action (gated by permission level + destructive blocklist). Why local-first matters Every other "browser session for AI" tool ships to a vendor cloud. peek's SQLite + extension live on the user's machine — no remote endpoints, no telemetry. The privacy policy (docs/peek/PRIVACY_POLICY.md) is the source of truth. Install # 1. Add the MCP server to Claude Code claude mcp add peek -- npx -y @peekdev/mcp # 2. Install the Chrome extension from the Chrome Web Store # (link added once the CWS listing is approved)

2 days ago