PowerBI MCP Server

Install

Works with Claude Code, Codex, VS Code, Cursor, Windsurf, Claude Desktop. Read the repository before you give any tool access to your data.

npx agentmarket install connector/gurvinder-dhillon-powerbi-mcp

About

No reviews yet. Installed it? Reviews come from verified installers only. How reviews work

Permissions

What this server can do and what it asks for, from its tool list and install config. Checked Oct 25, 2026.

Tools

6 read · 0 write · 0 delete · 1 not yet classified

Secrets

1 (API keys, tokens or passwords)

Install scripts

Not scanned yet

Runs as

Python package

Tools (7)

Read from the source code; the running server may differ. Descriptions are the server’s own words; hidden characters are shown as [U+…].

• get_dataset

  Get detailed information about a specific dataset. Retrieves comprehensive metadata about a PowerBI dataset including configuration, refresh settings, and data source information. Use this when you need to: - Get detailed metadata about a specific dataset - Check dataset configuration and capabilities - Verify dataset refresh settings - Understand dataset storage mode and requirements Parameters: - dataset_id (required): The unique identifier of the dataset - workspace_id (optional): Workspace (group) ID. Omit for datasets in "My workspace" - format: Response format - "json" or "markdown" (…

• get_datasets

  Get list of datasets from a specific workspace or My workspace. Datasets in PowerBI contain the data model, including tables, columns, relationships, and measures. This tool retrieves all datasets accessible in the specified workspace. Use this when you need to: - List all datasets in a workspace - Find a dataset ID for querying - Discover available data sources - Check dataset refresh status and configuration Parameters: - workspace_id (optional): Workspace (group) ID. If not provided, returns datasets from "My workspace" - format: Response format - "json" or "markdown" (default: "markdown…

• get_parameters

  Get parameters defined in a PowerBI dataset. Returns parameter definitions including: - Name and data type - Current value - Whether parameter is required - Suggested values (if defined) Useful for discovering available parameters before querying parameterized datasets. Note: Not supported for datasets with SQL, Oracle, Teradata, SAP HANA DirectQuery connections or datasets modified via XMLA endpoint. Parameters: - dataset_id (required): The dataset ID - workspace_id (optional): Workspace ID. Omit for datasets in "My workspace" - format: Response format - "markdown" or "json" (default: "ma…

• get_refresh_history

  Get refresh history for a PowerBI dataset. Shows recent refresh operations including: - Status (Completed, Failed, Unknown) - Start and end times - Request ID and refresh type - Error messages (for failed refreshes) Useful for monitoring data freshness and troubleshooting refresh failures. Parameters: - dataset_id (required): The dataset ID - workspace_id (optional): Workspace ID. Omit for datasets in "My workspace" - top: Number of refresh records to return (default: 5, max: 60) - format: Response format - "markdown" or "json" (default: "markdown") Returns: Formatted refresh history with …

• get_reports

  Get PowerBI reports from a workspace. Returns report information including: - Report name and ID - Web URL for viewing - Embed URL for embedding - Associated dataset ID Useful for discovering available reports and getting report URLs. Parameters: - workspace_id (optional): Workspace ID. Omit to get reports from "My workspace" - format: Response format - "json" or "markdown" (default: "markdown") - detail: Detail level - "concise" or "detailed" (default: "concise") Returns: List of reports with their IDs, names, and optionally URLs and dataset IDs. Example usage: - Get reports from My work…

• get_workspaces

  Get list of PowerBI workspaces (also called groups) accessible to the service principal. This tool retrieves all workspaces that the configured service principal has access to. Workspaces are containers for dashboards, reports, datasets, and dataflows in PowerBI. Use this when you need to: - Discover available workspaces - Find a workspace ID for further operations - List all accessible PowerBI workspaces Parameters: - top (optional): Maximum number of workspaces to return (1-5000, for pagination) - skip (optional): Number of workspaces to skip (for pagination) - format: Response format - "…

• query_dataset

  Execute DAX (Data Analysis Expressions) queries against a PowerBI dataset. This tool allows you to query dataset tables using DAX, PowerBI's formula language. DAX queries can retrieve data, perform calculations, and apply filters. Use this when you need to: - Retrieve data from dataset tables - Perform calculations and aggregations - Filter and analyze dataset data - Get specific rows or aggregated results DAX Query Syntax: - Basic table query: EVALUATE TableName - Filtered query: EVALUATE FILTER(TableName, TableName[Column] = "Value") - Aggregation: EVALUATE SUMMARIZE(TableName, TableName[…

Signals

Stars

0

Forks

0

Open issues

0

Weekly downloads

38

Last commit

Feb 5, 2026 (8 months ago)

Last release

Feb 5, 2026 (8 months ago)

Last package publish

Feb 5, 2026 (8 months ago)

From GitHub (fetched Oct 24, 2026) and the package registry.

Details

Registry name

io.github.gurvinder-dhillon/powerbi-mcp

Version

0.1.2

Auth

API key

Packages

pypi powerbi-mcp

License

MIT

Repository

github.com/gurvinder-dhillon/powerbi-mcp

First seen

Oct 24, 2026

Last checked

Oct 24, 2026

Source

Official MCP Registrygithub-graphql