Can I use Microsoft Power BI as a CLI?

Yes. KosmoKrator exposes a Microsoft Power BI CLI through kosmo integrations:call and the provider shortcut command. Commands can return JSON for scripts, CI, and coding agents.

Can I expose Microsoft Power BI through MCP?

Yes. The KosmoKrator MCP gateway can expose selected Microsoft Power BI tools to clients such as Claude Code, Cursor, Codex, and other MCP-compatible tools.

Where are Microsoft Power BI credentials stored?

Microsoft Power BI credentials are configured in KosmoKrator's local integration settings and reused by CLI, Lua, and MCP gateway surfaces.

Can I deny write access for Microsoft Power BI MCP tools?

Yes. Start the gateway with --write=deny for read-only clients, or use ask/allow only for trusted workspaces.

analytics

Microsoft Power BI CLI for AI Agents

Use the Microsoft Power BI CLI from KosmoKrator to call Microsoft Power BI tools headlessly, return JSON, inspect schemas, and automate workflows from coding agents, scripts, and CI.

6 functions 6 read 0 write Bearer token auth

Submit Microsoft Power BI feedback View package source

Microsoft Power BI CLI Setup

Microsoft Power BI can be configured headlessly with `kosmokrator integrations:configure microsoft_powerbi`.

# Install KosmoKrator first if it is not available on PATH.
curl -fsSL https://raw.githubusercontent.com/OpenCompanyApp/kosmokrator/main/install.sh | bash

# Configure and verify this integration.
kosmokrator integrations:configure microsoft_powerbi --set access_token="$MICROSOFT_POWERBI_ACCESS_TOKEN" --enable --read allow --write ask --json
kosmokrator integrations:doctor microsoft_powerbi --json
kosmokrator integrations:status --json

Credentials

Authentication type: Bearer token bearer_token. Configure credentials once, then use the same stored profile from scripts, coding CLIs, Lua code mode, and the MCP gateway.

Key	Env var	Type	Required	Label
`access_token`	`MICROSOFT_POWERBI_ACCESS_TOKEN`	Secret `secret`	yes	Access Token
`url`	`MICROSOFT_POWERBI_URL`	URL `url`	no	API Base URL

Call Microsoft Power BI Headlessly

Use the generic call form when another coding CLI or script needs a stable universal interface.

kosmo integrations:call microsoft_powerbi.powerbi_list_reports '{}' --json

Use the provider shortcut form for shorter human-facing commands.

kosmo integrations:microsoft_powerbi powerbi_list_reports '{}' --json

Agent Discovery Commands

These commands return structured output for coding agents that need to inspect capabilities before choosing a function.

kosmo integrations:docs microsoft_powerbi --json
kosmo integrations:docs microsoft_powerbi.powerbi_list_reports --json
kosmo integrations:schema microsoft_powerbi.powerbi_list_reports --json
kosmo integrations:search "Microsoft Power BI" --json
kosmo integrations:list --json

All CLI Functions

Every function below can be called headlessly. The generic form is stable across all integrations; the provider shortcut is shorter but specific to Microsoft Power BI.

`microsoft_powerbi.powerbi_list_reports`

Read read

List all Power BI reports the authenticated user has access to. Returns report names, IDs, embed URLs, and workspace associations.

Parameters: none

Generic CLI call

kosmo integrations:call microsoft_powerbi.powerbi_list_reports '{}' --json

Provider shortcut

kosmo integrations:microsoft_powerbi powerbi_list_reports '{}' --json

`microsoft_powerbi.powerbi_get_report`

Read read

Get details of a specific Power BI report by ID. Returns the report name, embed URL, dataset ID, and other metadata.

Parameters: report_id

Generic CLI call

kosmo integrations:call microsoft_powerbi.powerbi_get_report '{"report_id":"example_report_id"}' --json

Provider shortcut

kosmo integrations:microsoft_powerbi powerbi_get_report '{"report_id":"example_report_id"}' --json

`microsoft_powerbi.powerbi_list_datasets`

Read read

List all Power BI datasets the authenticated user has access to. Returns dataset names, IDs, and workspace associations.

Parameters: none

Generic CLI call

kosmo integrations:call microsoft_powerbi.powerbi_list_datasets '{}' --json

Provider shortcut

kosmo integrations:microsoft_powerbi powerbi_list_datasets '{}' --json

`microsoft_powerbi.powerbi_get_dataset`

Read read

Get details of a specific Power BI dataset by ID. Returns the dataset name, tables, default mode, and other metadata.

Parameters: dataset_id

Generic CLI call

kosmo integrations:call microsoft_powerbi.powerbi_get_dataset '{"dataset_id":"example_dataset_id"}' --json

Provider shortcut

kosmo integrations:microsoft_powerbi powerbi_get_dataset '{"dataset_id":"example_dataset_id"}' --json

`microsoft_powerbi.powerbi_list_workspaces`

Read read

List all Power BI workspaces (groups) the authenticated user has access to. Returns workspace names, IDs, and isolation modes.

Parameters: none

Generic CLI call

kosmo integrations:call microsoft_powerbi.powerbi_list_workspaces '{}' --json

Provider shortcut

kosmo integrations:microsoft_powerbi powerbi_list_workspaces '{}' --json

`microsoft_powerbi.powerbi_get_current_user`

Read read

Get the profile of the currently authenticated Power BI user. Returns display name, email address, and user identity details.

Parameters: none

Generic CLI call

kosmo integrations:call microsoft_powerbi.powerbi_get_current_user '{}' --json

Provider shortcut

kosmo integrations:microsoft_powerbi powerbi_get_current_user '{}' --json

Function Schemas

Use these parameter tables when building CLI payloads without calling integrations:schema first.

`microsoft_powerbi.powerbi_list_reports`

List all Power BI reports the authenticated user has access to. Returns report names, IDs, embed URLs, and workspace associations.

Operation: Read read
Schema command: kosmo integrations:schema microsoft_powerbi.powerbi_list_reports --json

Parameter	Type	Required	Description
No parameters.

`microsoft_powerbi.powerbi_get_report`

Get details of a specific Power BI report by ID. Returns the report name, embed URL, dataset ID, and other metadata.

Operation: Read read
Schema command: kosmo integrations:schema microsoft_powerbi.powerbi_get_report --json

Parameter	Type	Required	Description
`report_id`	string	yes	The unique ID of the Power BI report (GUID format).

`microsoft_powerbi.powerbi_list_datasets`

List all Power BI datasets the authenticated user has access to. Returns dataset names, IDs, and workspace associations.

Operation: Read read
Schema command: kosmo integrations:schema microsoft_powerbi.powerbi_list_datasets --json

Parameter	Type	Required	Description
No parameters.

`microsoft_powerbi.powerbi_get_dataset`

Get details of a specific Power BI dataset by ID. Returns the dataset name, tables, default mode, and other metadata.

Operation: Read read
Schema command: kosmo integrations:schema microsoft_powerbi.powerbi_get_dataset --json

Parameter	Type	Required	Description
`dataset_id`	string	yes	The unique ID of the Power BI dataset (GUID format).

`microsoft_powerbi.powerbi_list_workspaces`

List all Power BI workspaces (groups) the authenticated user has access to. Returns workspace names, IDs, and isolation modes.

Operation: Read read
Schema command: kosmo integrations:schema microsoft_powerbi.powerbi_list_workspaces --json

Parameter	Type	Required	Description
No parameters.

`microsoft_powerbi.powerbi_get_current_user`

Get the profile of the currently authenticated Power BI user. Returns display name, email address, and user identity details.

Operation: Read read
Schema command: kosmo integrations:schema microsoft_powerbi.powerbi_get_current_user --json

Parameter	Type	Required	Description
No parameters.

Permissions

Headless calls still follow the integration read/write permission policy. Configure read/write defaults with integrations:configure. Add --force only for trusted automation that should bypass that policy.