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

SocialAPIs — Facebook & Instagram Data

SocialAPIsHub

Facebook & Instagram data for AI agents — pages, posts, groups, Ads Library, Marketplace, profiles and reels. 47 read-only tools with structured output.

1
T

Texas RRC Wellbore Intelligence

TEOS

Texas RRC oil & gas wellbores: API numbers, completion dates, depth, plug status

Zillow MCP Server

HasData

HasData's hosted Zillow MCP server lets AI agents search homes for sale, rentals and sold listings, then retrieve property details, price history and Zillow estimates as structured JSON.

4

Tracetify — Competitor Ads, Growth Traces & Search Console

tracetify

17 tools for marketing and SEO research inside Claude Code, Cursor, Codex or ChatGPT: the ads any domain runs on Meta and Google, how a product grew from 12 public sources with every claim linked, your own Search Console

1

TofuBofu AI Visibility

Arnav Neil

TofuBofu runs a free AI visibility scan for any B2B company, right inside your AI assistant. Ask it to scan a domain and it runs the questions real buyers ask across ChatGPT, Claude, Gemini, Perplexity, Google AI Overvie

Advertise