A Model Context Protocol (MCP) server that enables AI assistants to interact with Power BI workspaces, datasets, reports, and dashboards programmatically.
🚀 Features
Workspace Management: List and manage Power BI workspaces
Report Operations: Access, clone, export, and rebind reports
Dataset Management: Execute DAX queries, refresh datasets, manage schedules
Dashboard Access: List and interact with dashboards
Push Datasets: Create and manage push datasets with real-time data
Authentication: Secure OAuth2 authentication with Microsoft Entra ID
📋 Prerequisites
Node.js (v18 or higher)
npm or yarn
Power BI Pro or Premium license
Microsoft Entra ID app registration
MCP-compatible AI assistant (Claude Desktop, etc.)
Server Config
{
"mcpServers": {
"powerbi-mcp-server": {
"command": "node",
"args": [
"path/to/powerbi-mcp-server/dist/index.js"
],
"env": {
"PBI_PUBLIC_CLIENT_ID": "your_client_id",
"PBI_TENANT_ID": "your_tenant_id"
}
}
}
}