KosmoKrator

analytics

Microsoft Power BI MCP, CLI, and Lua Integration for AI Agents

Microsoft Power BI integration docs for AI agents: MCP gateway setup, Microsoft Power BI CLI commands, Lua API reference, credentials, and function schemas.

7 functions 7 read 0 write Manual OAuth token auth

Microsoft Power BI for agents

Credentials can be configured manually in web or CLI hosts.

Use this integration from Lua code mode, the headless integrations CLI, or the KosmoKrator MCP gateway. The same package metadata powers all three surfaces.

Machine-Readable Metadata
integration_slug
powerbi
route_slug
powerbi
package
microsoft-power-bi
auth_strategy
oauth2_manual_token Manual OAuth token
cli_setup_supported
true
cli_runtime_supported
true
mcp_gateway_supported
true
lua_supported
true
supports_multi_account
true

Quick Links

Microsoft Power BI MCP Client Matrix

Use these pages when a specific agent client or framework needs copy-pasteable MCP setup for Microsoft Power BI.

Microsoft Power BI CLI Matrix

Use these pages for direct Microsoft Power BI CLI workflows in scripts, CI, cron, and agent wrappers.

Function Catalog

FunctionTypeParametersDescription
powerbi.powerbi_list_workspaces Read read 1 List Power BI workspaces (groups) the authenticated user has access to. Returns workspace IDs and names that can be used to query datasets and reports.
powerbi.powerbi_get_workspace Read read 1 Get details for a specific Power BI workspace (group) by its ID.
powerbi.powerbi_list_datasets Read read 1 List datasets within a Power BI workspace. Returns dataset IDs, names, and configuration details.
powerbi.powerbi_get_dataset Read read 2 Get details for a specific Power BI dataset within a workspace, including schema and refresh configuration.
powerbi.powerbi_list_reports Read read 1 List reports within a Power BI workspace. Returns report IDs, names, embed URLs, and associated dataset IDs.
powerbi.powerbi_get_report Read read 2 Get details for a specific Power BI report within a workspace, including embed URL and associated dataset.
powerbi.powerbi_get_current_user Read read 0 Get the authenticated user's Power BI profile, including display name and email address.