Power Bi Mcp Server
@michaelmckinleyconsulting
Power Bi Mcp Server について
A Model Context Protocol (MCP) server that enables AI assistants to interact with Power BI workspaces, datasets, reports, and dashboards programmatically.
基本情報
設定
以下の設定を使って、このサーバーを MCP 対応クライアントに追加してください。
{
"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"
}
}
}
}ツール
ツールは検出されませんでした
ツールは README から自動的に抽出されます。メンテナーは ## Tools という見出しの下に記載することで、このタブに反映できます。
概要
What is Power Bi Mcp Server?
Power Bi Mcp Server is a Model Context Protocol (MCP) server that enables AI assistants to interact with Power BI workspaces, datasets, reports, and dashboards programmatically. It is intended for users who want to manage Power BI resources through an AI assistant like Claude Desktop.
How to use Power Bi Mcp Server?
Install dependencies with npm install, build with npm run build, then configure an MCP client (e.g., Claude Desktop) by setting environment variables PBI_PUBLIC_CLIENT_ID and optionally PBI_TENANT_ID. The server supports Authorization Code flow with PKCE and interactive browser login on first run.
Key features of Power Bi Mcp Server
- 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
Use cases of Power Bi Mcp Server
- List all Power BI workspaces from an AI assistant
- Execute DAX queries against a dataset and get results
- Export reports to PDF, PPTX, or PNG format
- Trigger dataset refreshes and view refresh history
- Create push datasets for real-time data monitoring
FAQ from Power Bi Mcp Server
What prerequisites are needed?
Node.js v18 or higher, npm or yarn, a Power BI Pro or Premium license, and a Microsoft Entra ID app registration.
How does authentication work?
It supports interactive user sign-in via browser (Authorization Code flow with PKCE) or app-only authentication using client credentials with admin consent.
What Power BI operations are supported?
Workspace listing and user management; report cloning, exporting, and rebinding; dataset DAX queries, refreshes, and schedule management; dashboard listing; and push dataset creation and row insertion.
What transports are supported?
The server uses stdio transport for MCP, configured via the command and args fields in the MCP client settings.
Is the software open source?
It is source-available under a Modified MIT License with Commons Clause. It is free for non-commercial use, including personal, educational, and internal company use. Commercial use requires a separate license.
「データと分析」の他のコンテンツ
PubMed MCP Server
JackKuo666🔍 Enable AI assistants to search, access, and analyze PubMed articles through a simple MCP interface.
🪐✨ Jupyter MCP Server
datalayer🪐 🔧 Model Context Protocol (MCP) Server for Jupyter.
PubMed Analysis MCP Server
DarkroasterA PubMed MCP server.
Google Ads MCP
cohnenAn MCP tool that connects Google Ads with Claude AI/Cursor and others, allowing you to analyze your advertising data through natural language conversations. This integration gives you access to campaign information, performance metrics, keyword analytics, and ad management—all th
Bright Data MCP
luminati-ioA powerful Model Context Protocol (MCP) server that provides an all-in-one solution for public web access.
コメント