MCP.so
Sign In
P

Power Bi Mcp Server

@michaelmckinleyconsulting

Repository

About Power Bi Mcp Server

A Model Context Protocol (MCP) server that enables AI assistants to interact with Power BI workspaces, datasets, reports, and dashboards programmatically.

#power-bi#mcp-server#ai-assistant

Basic information

Category

Data & Analytics

Transports

stdio

Publisher

michaelmckinleyconsulting

Submitted by

McKinley Consulting

Config

Add this server to your MCP-compatible client using the configuration below.

{
  "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"
      }
    }
  }
}

Tools

No tools detected

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

What is Power Bi Mcp Server?

Power Bi Mcp Server is a Model Context Protocol (MCP) server that enables AI assistants to interact with Power BI workspaces, datasets, reports, and dashboards programmatically. It is intended for users who want to manage Power BI resources through an AI assistant like Claude Desktop.

How to use Power Bi Mcp Server?

Install dependencies with npm install, build with npm run build, then configure an MCP client (e.g., Claude Desktop) by setting environment variables PBI_PUBLIC_CLIENT_ID and optionally PBI_TENANT_ID. The server supports Authorization Code flow with PKCE and interactive browser login on first run.

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, 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

  • List all Power BI workspaces from an AI assistant
  • Execute DAX queries against a dataset and get results
  • Export reports to PDF, PPTX, or PNG format
  • Trigger dataset refreshes and view refresh history
  • Create push datasets for real-time data monitoring

FAQ from Power Bi Mcp Server

What prerequisites are needed?

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

How does authentication work?

It supports interactive user sign-in via browser (Authorization Code flow with PKCE) or app-only authentication using client credentials with admin consent.

What Power BI operations are supported?

Workspace listing and user management; report cloning, exporting, and rebinding; dataset DAX queries, refreshes, and schedule management; dashboard listing; and push dataset creation and row insertion.

What transports are supported?

The server uses stdio transport for MCP, configured via the command and args fields in the MCP client settings.

Is the software open source?

It is source-available under a Modified MIT License with Commons Clause. It is free for non-commercial use, including personal, educational, and internal company use. Commercial use requires a separate license.

Comments

More Data & Analytics MCP servers

PubMed Analysis MCP Server

Darkroaster

A PubMed MCP server.

150

MCP Simple PubMed

andybrandt

MCP server for searching and querying PubMed medical papers/research database

168

Google Analytics MCP Server

surendranb

Google Analytics 4 data to AI agents, agentic workflows, and MCP clients. Give agents analysis-ready access to website traffic, user behavior, and performance data with schema discovery, server-side aggregation, and safe defaults that reduce data wrangling.

225

Web3 Research MCP

aaronjmars

Deep Research for crypto - free & fully local

161

🎓 Semantic Scholar MCP Server

JackKuo666

🔍 This project implements a Model Context Protocol (MCP) server for interacting with the Semantic Scholar API. It provides tools for searching papers, retrieving paper and author details, and fetching citations and references.

75