Advertise
MCP.so
Sign In
P

Power Bi MCP Server

@michaelmckinleyconsulting

Repository

Basic information

Category

Data & Analytics

Transports

stdio

Author

michaelmckinleyconsulting

Submitted by

McKinley Consulting

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

Power Bi MCP Server 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"
      }
    }
  }
}

Power Bi MCP Server tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

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

Frequently asked questions

1

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.

2

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.

3

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.

4

What transports are supported?

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

5

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

Aard

Braddon Lance

Aard connects Macroeconomic and other official data from 170+ publishers including World Bank, IMF, BIS, ECB, Eurostat, and National Statistical Offices. Aard is powered by a large graph of the metadata universe and an

TikTok MCP Server

HasData

Hosted TikTok MCP server for AI agents: read public profiles, account videos, comments and replies, or search videos and creators. Structured JSON for creator research and content analysis.

3

SportsTrackLive

STL Solutions

SportsTrackLive is a remote MCP server available at https://mcp.sportstracklive.com. SportsTrackLive is a Live Tracking solution and let you record, share and relive your Tracks! SportsTrackLive provide a real-time tra

Rivalize

Downshift

Competitive intelligence for AI agents: competitor teardowns, pricing, ads, reviews and momentum, cited and dated. Read-only by default.

Airside Labs Aviation Tools

Airside Labs

Validated aviation reference tools for AI agents: resolve airports, airlines, aircraft types, registrations and flight designators to canonical entities with confidence, alternates, validity dates and per-field provenanc

Advertise