Power BI Analyst MCP Server

Source profile for Power BI Analyst MCP. Its purpose and connection details need verification against the maintainer’s documentation.

Local serverstdio

What is the Power BI Analyst MCP Server?

This Power BI Analyst MCP source profile is awaiting review. The previous overview contained a logo or badge fragment rather than a usable description. Check the linked maintainer documentation for the server’s purpose and connection details.

Installation

The documented pypi package is powerbi-analyst-mcp. The configuration below comes from the maintainer’s example; adapt its paths and account values to your environment.

Configuration values

The example declares POWERBI_CLIENT_ID, POWERBI_TENANT_ID. Secret-looking values have been replaced with placeholders. Required and optional labels are shown only when the documentation states them.

Source

Project documentation · Repository · Discovery listing. This profile records the public documentation checked on 2026-10-08.

Recorded tools

Check the linked publisher documentation and your connected client's tool list. Names and availability can vary with the server version and account permissions.

ToolWhat it does
authenticateSign in via OAuth device code — returns a URL + one-time code; call again to complete
logoutClear the cached token (forces re-authentication)
list_appsList all Power BI apps you have access to — start here; returns workspaceId for each app
list_datasetsList datasets / semantic models in a workspace (use workspaceId from list_apps)
get_dataset_infoMetadata and last 5 refresh history entries for a dataset
list_tablesAll visible tables in a dataset
list_measuresMeasures with name, table, description, and format string
list_columnsColumns with data type and key flag
execute_daxRun a DAX query — inline for small results, local CSV for large ones. Pass query_summary to log the query for future reference.
read_query_resultPage through a large CSV result without loading it all into context
search_query_historySearch the local query log by keyword, dataset, or time range — find prior DAX and results across sessions
delete_query_log_entryRemove a query log entry (e.g. when the approach turned out to be wrong)

How to install the Power BI Analyst MCP Server

{
  "mcpServers": {
    "powerbi": {
      "command": "uvx",
      "args": [
        "powerbi-analyst-mcp"
      ],
      "env": {
        "POWERBI_CLIENT_ID": "your-application-client-id",
        "POWERBI_TENANT_ID": "your-directory-tenant-id"
      }
    }
  }
}

From the project documentation. Replace placeholders and example paths before connecting.

Configuration

VariableDescriptionRequired
POWERBI_CLIENT_IDDeclared in the maintainer’s client configuration.Check documentation
POWERBI_TENANT_IDDeclared in the maintainer’s client configuration.Yes