Server facts
powerbi-analyst-mcp
Project
- Author
- mbrummerstedt
- License
- Not specified
- Category
- Data & Analytics
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.