Power BI

Provides an MCP server that enables talking to Power BI workspaces, reports, datasets, and dashboards via MCP clients.

typescript

GitHub Stars

typescript

Language

5 months ago

First Indexed

2 months ago

Catalog Refreshed

Documentation & install

Readme and setup notes from the catalogue, plus a client-ready config you can copy for your MCP host.

Installation

Add the following to your MCP client configuration file.

Configuration

View docs

{
  "mcpServers": {
    "michaelmckinleyconsulting-power-bi-mcp-server": {
      "command": "node",
      "args": [
        "path/to/powerbi-mcp-server/dist/index.js"
      ],
      "env": {
        "PBI_SCOPES": "https://analysis.windows.net/powerbi/api/.default",
        "PBI_TENANT_ID": "your_tenant_id",
        "PBI_PUBLIC_CLIENT_ID": "your_client_id"
      }
    }
  }
}

You run a Power BI MCP Server to let AI assistants interact with Power BI workspaces, reports, datasets, and dashboards. It provides secure authentication, supports common operations, and can be configured to work with your MCP-enabled client of choice for conversational data tasks.

How to use

You configure an MCP client to connect to the server, then issue natural language prompts to perform actions such as listing workspaces, running DAX queries, exporting reports, refreshing datasets, or managing access. The server translates those prompts into Power BI REST API calls and returns results you can present to users.

How to install

prerequisites include Node.js 18 or higher and a package manager such as npm or yarn. You also need a Power BI Pro or Premium license and an Entra ID app registration to enable OAuth authentication. Follow these steps to set up the server and run it locally.

# Step 1: Clone the project repository
git clone https://github.com/michaelmckinleyconsulting/powerbi-mcp-server.git
cd powerbi-mcp-server

# Step 2: Install dependencies
npm install

# Step 3: Build the project
npm run build

# Step 4: Start the server (example)
node dist/index.js

Additional configuration and notes

Configuration includes setting up a Microsoft Entra ID app for OAuth and providing environment variables so the server can authenticate and access Power BI resources.

Environment variables you will configure include client and tenant identifiers, as well as the required scopes for Power BI API access.

Available tools

Workspace management

List and manage Power BI workspaces including getting users and adjusting access.

Report operations

Access, clone, export, and rebind reports to different datasets.

Dataset management

Execute DAX queries, trigger refreshes, and manage refresh schedules.

Dashboard access

List dashboards and interact with their tiles.

Push datasets

Create and populate push datasets for real-time data ingestion.

Authentication

Secure OAuth2 authentication with Microsoft Entra ID, including interactive and app-only modes.

Built by

VeilStrat

AI signals for GTM teams