Advertise
MCP.so
Sign In
P

Power Bi MCP Server

@michaelmckinleyconsulting

Repository

Basic information

Category

Data & Analytics

Last updated

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

Ask Xverum

Xverum-LLC

Find and enrich the right people and companies in plain English. Built for AI agents: 750M professional profiles, 54M company profiles, 200M+ verified business emails and phone numbers, and job-change scores with Next Mo

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

Bounce Watch - Company Signal Intelligence

bouncewatch

Bounce Watch tells you what just changed at a company, and when. Who raised money. Who hired a senior person. Who opened an office, won a customer, or announced a partnership. Every event carries its own date, so you ca

YouTube MCP Server

HasData

Hosted YouTube MCP server for search, video metadata, channel data and timestamped transcripts. Connect Claude, Cursor or other MCP clients with HasData; no YouTube API key required.

6

Subtext

Subtext by Fullstory

Session replay, built for agents. Subtext is agentic session review: it captures production sessions of your app and connects them to your coding agent — Claude Code, Cursor, Codex, Devin, your own harness — so it can

9
Advertise