Connect Claude to your Power BI semantic models. Browse workspaces, tables, and measures, run DAX queries, and get results — with large datasets automatically saved to local CSV files to protect the LLM context window. Includes a query history log for cross-session reuse and auditability.
Tools
authenticate
logout
list_workspaces
list_datasets
get_dataset_info
list_tables
list_measures
list_columns
execute_dax
read_query_result
search_query_history
delete_query_log_entry
Server Config
{
"mcpServers": {
"powerbi": {
"command": "uvx",
"args": [
"powerbi-analyst-mcp"
],
"env": {
"POWERBI_CLIENT_ID": "<YOUR_CLIENT_ID>",
"POWERBI_TENANT_ID": "<YOUR_TENANT_ID>"
}
}
}
}