Microsoft Apps114 toolsBrowser login (OAuth), no API keys
Power BI integration for AI agents
Query datasets and manage reports, dashboards, and workspaces
Use it from your agent
One ClawLink account serves every agent you run. Pick the guide for yours, or connect Power BI once and call the same tools from all of them.
Power BI for OpenClawInstall, pair, connect, first prompt
Power BI for Hermes AgentInstall, pair, connect, first promptMCPClaude Code, Cursor, any MCP clientCLI login or the remote MCP serverSetup
Connect Power BI through ClawLink's hosted setup to list workspaces, reports, dashboards and datasets, run DAX queries and refresh datasets. Power BI needs a work or school Microsoft account; personal accounts cannot sign in. Your organization may show "Need admin approval": ask your IT admin to approve ClawLink once.
- Auth: Browser login (OAuth), no API keys. The credential stays on the ClawLink server; your agent holds only a ClawLink key you can revoke.
- Where: the ClawLink dashboard, or ask your agent to connect it.
What your agent can do
Power BI exposes 114 tools through ClawLink. The 30 most used are listed here; your agent sees all of them.
| Tool | What it does | Kind |
|---|---|---|
microsoft_power_bi_apps_get_reports | Returns a list of reports from the specified app | Read |
microsoft_power_bi_discover_gateways | Returns a list of gateways that the specified dataset from the specified workspace can be bound | Read |
microsoft_power_bi_execute_dax_queries | Executes Data Analysis Expressions (DAX) queries against the provided dataset in My workspace | Read |
microsoft_power_bi_execute_queries_2 | Executes Data Analysis Expressions (DAX) queries against the specified Power BI dataset | Read |
microsoft_power_bi_get_available_feature_by_name | Returns the specified available feature for the user by name | Read |
microsoft_power_bi_get_capacities | Returns a list of Power BI capacities that the authenticated user has access to | Read |
microsoft_power_bi_get_dashboard2 | Returns the specified dashboard from My workspace | Read |
microsoft_power_bi_get_dashboards | Returns a list of dashboards from the specified workspace | Read |
microsoft_power_bi_get_data_set_data | Gets the query results for the specified DataSet | Read |
microsoft_power_bi_get_data_sets | Gets an array of DataSet CatalogItems from Power BI | Read |
microsoft_power_bi_get_dataflows | Returns a list of all dataflows from the specified workspace | Read |
microsoft_power_bi_get_dataset | Returns the specified dataset from My workspace | Read |
microsoft_power_bi_get_dataset_to_dataflows_links | Returns a list of upstream dataflows for datasets from the specified workspace | Read |
microsoft_power_bi_get_dataset_users | Returns a list of principals that have access to the specified dataset | Read |
microsoft_power_bi_get_dataset_users_in_group | Returns a list of principals that have access to the specified dataset within a workspace | Read |
microsoft_power_bi_get_dataset2 | Returns the specified dataset from the specified workspace | Read |
microsoft_power_bi_get_datasets | Returns a list of datasets from My workspace | Read |
microsoft_power_bi_get_datasources | Returns a list of data sources for the specified dataset from My workspace | Read |
microsoft_power_bi_get_datasources_in_group3 | Returns a list of data sources for the specified dataset from the specified workspace | Read |
microsoft_power_bi_get_gateway | Returns the specified gateway | Read |
microsoft_power_bi_get_gateway_datasources_in_group | Returns a list of gateway data sources for the specified dataset from the specified workspace | Read |
microsoft_power_bi_get_gateways | Returns a list of gateways for which the user is an admin | Read |
microsoft_power_bi_get_goal_value_by_id | Reads a goal value check-in by a UTC date timestamp | Read |
microsoft_power_bi_get_goals | Returns a list of goals from a scorecard | Read |
microsoft_power_bi_get_goals_refresh_history | Reads refresh history of a connected goal | Read |
microsoft_power_bi_get_goals_status_rules | Returns status rules of a goal | Read |
microsoft_power_bi_get_group_users | Returns a list of users that have access to the specified workspace | Read |
microsoft_power_bi_get_groups | Returns a list of workspaces the user has access to | Read |
microsoft_power_bi_get_groups_capacity_assignment_status | Gets the status of the assignment-to-capacity operation for the specified workspace | Read |
microsoft_power_bi_get_import | Returns the specified import from My workspace | Read |
