Power BI Analyst MCP

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/mbrummerstedt-powerbi-analyst-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

8 read · 3 write · 1 delete

Secrets

None asked for

Install scripts

Not scanned yet

Runs as

Python package

Tools (12)

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

• authenticate

  Authenticate with Power BI using the OAuth 2.0 device code flow. Call this tool first if you have never logged in, or if a previous call returned "Not authenticated". The tool uses a two-step flow: - First call: returns a URL and a one-time code for you to open in a browser. - Second call: completes the authentication after you have signed in. Your credentials are cached locally so you will not need to repeat this step until the refresh token expires (~90 days).

• delete_query_log_entry

  Remove a single entry from the query history log. Use this when a query produced incorrect or misleading results and should not appear in future history searches. The associated CSV file (if any) is NOT deleted — only the log entry is removed.

• execute_dax

  Execute a DAX query against a Power BI dataset and return the result rows. The query must start with EVALUATE (standard DAX query syntax). Results are returned as a JSON array of objects, with column names as keys. Small results (<= 50 rows) are returned inline as JSON. Large results (> 50 rows) are automatically saved to a CSV file and a compact summary is returned with the file path, column names, row count, and a preview of the first 5 rows. Use `read_query_result` to page through a saved CSV, or read the file directly. Every successful execution is logged to a local history file for aud…

• get_dataset_info

  Return detailed metadata for a single Power BI dataset. Includes name, owner, refresh schedule, storage mode, web URL, and more. Also returns the last 5 refresh history entries so you can see data freshness.

• list_columns

  List columns (dimensions) in a Power BI dataset. Returns each column's name, parent table, description, data type, and whether it is a key column. Optionally filter by table name.

• list_datasets

  List all datasets (semantic models) in a Power BI workspace. Returns dataset id, name, configured-by, web URL, is-refreshable flag, and the target storage mode (Import / DirectQuery / etc.). Use the `id` field as `dataset_id` in subsequent tools.

• list_measures

  List measures defined in a Power BI dataset. Returns each measure's name, parent table, description, and format string. Optionally filter by table name.

• list_tables

  List all visible tables in a Power BI dataset. Hidden tables and internal Power BI system tables (names starting with '$') are excluded. Use the returned table names in `list_measures`, `list_columns`, and DAX queries.

• list_workspaces

  List all Power BI workspaces (groups) the authenticated user is a member of. Returns workspace id, name, type, and capacity information. Use the `id` field as `workspace_id` in subsequent tools.

• logout

  Sign out of Power BI by clearing the cached credentials. After logging out, call `authenticate` to sign in again.

• read_query_result

  Read a page of rows from a CSV file saved by `execute_dax`. Use this tool when `execute_dax` returns a `savedTo` path instead of inline rows. Combine `offset` and `limit` to page through large results without loading the entire file into context. Returns rows for the requested slice together with pagination metadata: - totalRows: total number of rows in the file - offset: the offset used - limit: the limit used - hasMore: whether more rows exist after this page Example workflow: 1. Call `execute_dax` — if rows > 50 you get a savedTo path. 2. Call `read_query_result(file_path=savedTo, offset…

• search_query_history

  Search the local query history log for prior DAX executions. Every successful `execute_dax` call is logged with the DAX query, a short summary of what the user asked for, the result shape, and the path to any saved CSV file. Use this tool to: - Find previous queries for a dataset so you can reuse or adapt the DAX - Locate saved CSV files from earlier sessions - Audit what data has been pulled and when - Avoid re-running expensive queries when the data already exists locally Results are returned newest-first. Use `keyword` to search by intent (e.g. "revenue by market") — it matches against t…

Signals

Weekly downloads

41

Last release

Mar 13, 2026 (7 months ago)

Last package publish

Mar 13, 2026 (7 months ago)

From the package registry.

Details

Registry name

io.github.mbrummerstedt/powerbi-analyst-mcp

Version

0.1.1

Auth

No auth

Packages

pypi powerbi-analyst-mcp

License

MIT

First seen

Oct 24, 2026

Last checked

Oct 24, 2026

Source

Official MCP Registry