powerbi-analyst-mcp

Powerbi Analyst MCP Server

powerbi-analyst-mcp connects Claude to Power BI for analysts exploring semantic models and running DAX queries. It supports workspace and model discovery, saves larger results as local CSV files, and keeps searchable query history across sessions.

Server facts

powerbi-analyst-mcp

Project

License
Not specified

Tech

Runtime / language
Not specified
Transports
stdio
Remote available
No
Authentication
Not specified

Activity

GitHub stars
14
Last commit
Data as of

Tags

  • Data Analysis
  • analytics
  • business intelligence
  • dax
  • power bi
  • powerbi

Overview

Power BI workspaces, semantic models, and DAX results become accessible to Claude through a locally running connection to the Power BI REST API. Users authenticate through an OAuth device-code flow, then browse their workspace memberships and datasets. Model inspection covers visible tables, measures, and columns, including descriptions, formatting, data types, and key-column metadata. Dataset details also expose ownership, storage mode, refresh schedules, and recent refresh history, giving analysts context before they query. Credentials are cached locally using operating-system secure storage, and logout clears them.

DAX execution returns results containing up to 50 rows directly as JSON. Larger outputs go to local CSV files, while the assistant receives a compact response containing the path, columns, row count, and a preview. A separate tool retrieves selected portions of those files with pagination metadata. Successful queries enter a local history log containing the DAX, user intent, result details, and any CSV path. Analysts can search that history across sessions to reuse queries or locate earlier exports. Removing a history entry leaves its associated CSV intact.

powerbi-analyst-mcp setup notes

  • powerbi-analyst-mcp records stdio only; confirm a network transport upstream before planning remote access.
  • powerbi-analyst-mcp has no recorded license; confirm reuse terms in its repository.

Related MCP servers