Power Bi Mcp Server

Name: Power Bi Mcp Server
Author: michaelmckinleyconsulting

@michaelmckinleyconsulting

关于 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

基本信息

分类

数据与分析

传输方式

stdio

发布者

michaelmckinleyconsulting

提交者

McKinley Consulting

配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

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

工具

未检测到工具

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

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.

数据与分析分类下的更多 MCP 服务器

MCP Simple PubMed

andybrandt

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

168

Healthcare MCP Server

Cicatriiz

A Model Context Protocol (MCP) server providing AI assistants with access to healthcare data and medical information tools, including FDA drug info, PubMed, medRxiv, NCBI Bookshelf, clinical trials, ICD-10, DICOM metadata, and a medical calculator.

117