Power Bi Mcp Server

Created By

michaelmckinleyconsultinga month ago

A Model Context Protocol (MCP) server that enables AI assistants to interact with Power BI workspaces, datasets, reports, and dashboards programmatically. 🚀 Features 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 📋 Prerequisites Node.js (v18 or higher) npm or yarn Power BI Pro or Premium license Microsoft Entra ID app registration MCP-compatible AI assistant (Claude Desktop, etc.)

# power-bi

# mcp-server

Overview Content Tools Comments

Overview

What is Power BI MCP Server?

Power BI MCP Server is a Model Context Protocol (MCP) server that allows AI assistants to programmatically interact with Power BI workspaces, datasets, reports, and dashboards.

How to use Power BI MCP Server?

To use the Power BI MCP Server, clone the repository, install the dependencies, and configure the Microsoft Entra ID for authentication. Once set up, your AI assistant can perform various operations on Power BI.

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

Automating report generation and distribution.
Managing datasets and executing complex DAX queries.
Integrating Power BI functionalities into AI-driven applications.

FAQ from Power BI MCP Server?

What are the prerequisites for using Power BI MCP Server?

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

Is there a cost associated with using Power BI MCP Server?

The server is free for personal, educational, and internal company use, but requires a commercial license for commercial use.

What kind of operations can I perform with this server?

You can list workspaces, execute DAX queries, export reports, refresh datasets, and manage push datasets.

Server Config

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

Recommend Servers

TraeBuild with Free GPT-4.1 & Claude 3.7. Fully MCP-Ready.

CursorThe AI Code Editor

Howtocook Mcp基于Anduin2017 / HowToCook （程序员在家做饭指南）的mcp server，帮你推荐菜谱、规划膳食，解决“今天吃什么“的世纪难题； Based on Anduin2017/HowToCook (Programmer's Guide to Cooking at Home), MCP Server helps you recommend recipes, plan meals, and solve the century old problem of "what to eat today"

ChatWiseThe second fastest AI chatbot™

BlenderBlenderMCP connects Blender to Claude AI through the Model Context Protocol (MCP), allowing Claude to directly interact with and control Blender. This integration enables prompt assisted 3D modeling, scene creation, and manipulation.

DeepChatYour AI Partner on Desktop

Amap Maps高德地图官方 MCP Server

AiimagemultistyleA Model Context Protocol (MCP) server for image generation and manipulation using fal.ai's Stable Diffusion model.

Serper MCP ServerA Serper MCP Server

Zhipu Web SearchZhipu Web Search MCP Server is a search engine specifically designed for large models. It integrates four search engines, allowing users to flexibly compare and switch between them. Building upon the web crawling and ranking capabilities of traditional search engines, it enhances intent recognition capabilities, returning results more suitable for large model processing (such as webpage titles, URLs, summaries, site names, site icons, etc.). This helps AI applications achieve "dynamic knowledge acquisition" and "precise scenario adaptation" capabilities.

MiniMax MCPOfficial MiniMax Model Context Protocol (MCP) server that enables interaction with powerful Text to Speech, image generation and video generation APIs.