ClawLink

How to connect Power BI to Hermes Agent

Connect Power BI to Hermes with ClawLink in one click — 277 tools your AI agent can call from chat via hosted OAuth. No API keys, no manual setup.

Get started for free
Hermes Agent
Hermes Agent
ClawLink
ClawLink
Power BI
Power BI
Power BIOAUTH2MCP

Query datasets and manage reports, dashboards, and workspaces. Once connected, Hermes Agent can read and act on Power BI from chat — pairing, token refresh, and tool wiring handled for you.

277 tools

Most guides for giving Hermes Agent Power BI access start with registering your own OAuth app or pasting API keys into env files, then leave the token refresh and tool wiring to you. ClawLink gives Hermes a more practical Power BI setup: pair once in the browser and your always-on Hermes agent can act on Power BI for you, reading and doing real work on your behalf with no auth, token refresh, or tool wiring to build yourself.

Setup

It takes three steps to connect Hermes to Power BI.

  1. 1

    Install and pair

    Install the ClawLink plugin, then pair Hermes with a one-time browser approval:

    hermes plugins install ClawLink-HQ/hermes-plugin --enable
  2. 2

    Connect Power BI

    One-click OAuth in the dashboard.

  3. 3

    Use it from chat

    Ask Hermes Agent: "What can you do with Power BI?"

Install by command

The prompt above walks Hermes through this. By hand, it is four commands and a browser approval:

hermes plugins install ClawLink-HQ/hermes-plugin --enable
hermes clawlink begin    # prints an approval link — open it and approve
hermes clawlink finish   # after approving in the browser
hermes clawlink test

Then connect Power BI in the ClawLink dashboard — a one-click OAuth approval, no API keys.

Verify the connection by asking Hermes:

List my Power BI workspaces and the reports in each one.

Using a different agent?

The Hermes plugin is one client of ClawLink's MCP server. Claude Code, Cursor, Codex, or any agent that can run a shell command pairs with the same ClawLink account through the CLI:

npx -y @useclawlink/cli login

login opens the same browser approval and stores a credential locally. Once Power BI is connected in the dashboard, that agent calls the same 277 Power BI tools over MCP. Full setup for MCP clients and shell agents: connect apps to any AI agent.

Power BI MCP for Hermes

Looking for a Power BI MCP server for Hermes Agent? ClawLink connects Power BI to Hermes Agent and exposes 277 Power BI tools your agent can call over MCP, with hosted auth and nothing to run or maintain yourself. Using OpenClaw instead? The OpenClaw Power BI integration works the same way.

What the Hermes Agent Power BI integration can do

277 Power BI tools are ready for Hermes Agent once the account is connected. The 30 below are the ones people reach for most; your agent can call all 277.

30 of 277 Power BI tools for Hermes

ToolWhat it does
Microsoft power bi admin list modified workspaces microsoft_power_bi_admin_list_modified_workspacesList organization workspace IDs, optionally filtered by modification date
Microsoft power bi admin list org shared report links microsoft_power_bi_admin_list_org_shared_report_linksList reports shared to the whole organization through links
Microsoft power bi admin list pipelines microsoft_power_bi_admin_list_pipelinesList organization deployment pipelines as admin
Microsoft power bi admin list service principal profiles microsoft_power_bi_admin_list_service_principal_profilesList organization service-principal profiles
Microsoft power bi apps get reports microsoft_power_bi_apps_get_reportsReturns a list of reports from the specified app
Microsoft power bi check gateway data source connectivity microsoft_power_bi_check_gateway_data_source_connectivityCheck gateway data source connectivity
Microsoft power bi discover gateways microsoft_power_bi_discover_gatewaysReturns a list of gateways that the specified dataset from the specified workspace can be bound
Microsoft power bi download workspace report export microsoft_power_bi_download_workspace_report_exportRetrieve the completed export-job file for a workspace report as a platform-managed
Microsoft power bi execute dax queries microsoft_power_bi_execute_dax_queriesExecutes DAX queries against a capacity-hosted dataset in My workspace, with options for RLS
Microsoft power bi execute queries 2 microsoft_power_bi_execute_queries_2Executes Data Analysis Expressions (DAX) queries against the specified Power BI dataset
Microsoft power bi export a dataflow definition as admin microsoft_power_bi_export_a_dataflow_definition_as_adminExport the specified dataflow definition as a downloadable JSON file reference
Microsoft power bi export a dataflow definition as json microsoft_power_bi_export_a_dataflow_definition_as_jsonExport a workspace dataflow definition as a platform-managed downloadable JSON file reference
Microsoft power bi export a workspace report as pbix or rdl microsoft_power_bi_export_a_workspace_report_as_pbix_or_rdlExport a workspace report as a downloadable PBIX or RDL file reference
Microsoft power bi get a capacity refreshable as admin microsoft_power_bi_get_a_capacity_refreshable_as_adminReturn a capacity refreshable and its refresh statistics as an admin
Microsoft power bi get a capacity workload state microsoft_power_bi_get_a_capacity_workload_stateGet a capacity workload state
Microsoft power bi get a dashboard from an app microsoft_power_bi_get_a_dashboard_from_an_appGet a dashboard from an app
Microsoft power bi get a dashboard in a workspace microsoft_power_bi_get_a_dashboard_in_a_workspaceGet a dashboard in a workspace
Microsoft power bi get a dashboard tile in a workspace microsoft_power_bi_get_a_dashboard_tile_in_a_workspaceGet a dashboard tile in a workspace
Microsoft power bi get a dashboard tile in my workspace microsoft_power_bi_get_a_dashboard_tile_in_my_workspaceGet a dashboard tile in My workspace
Microsoft power bi get a deployment pipeline microsoft_power_bi_get_a_deployment_pipelineGet a deployment pipeline
Microsoft power bi get a gateway data source microsoft_power_bi_get_a_gateway_data_sourceGet a gateway data source
Microsoft power bi get a report from an app microsoft_power_bi_get_a_report_from_an_appGet a report from an app
Microsoft power bi get a report in a workspace microsoft_power_bi_get_a_report_in_a_workspaceGet a report in a workspace
Microsoft power bi get a service principal profile microsoft_power_bi_get_a_service_principal_profileGet a service-principal profile
Microsoft power bi get a tile from an app dashboard microsoft_power_bi_get_a_tile_from_an_app_dashboardGet a tile from an app dashboard
Microsoft power bi get an import in a workspace microsoft_power_bi_get_an_import_in_a_workspaceGet an import in a workspace
Microsoft power bi get an installed app microsoft_power_bi_get_an_installed_appGet an installed app
Microsoft power bi get an organization workspace as admin microsoft_power_bi_get_an_organization_workspace_as_adminGet an organization workspace as admin
Microsoft power bi get available feature by name microsoft_power_bi_get_available_feature_by_nameReturns the specified available feature for the user by name
Microsoft power bi get capacities microsoft_power_bi_get_capacitiesLists the Power BI capacities accessible to the authenticated user, with information such as

Try it: find the Power BI tool you need

Browse the 30 Power BI tools

Click any tool to see exactly what Hermes can do and copy a ready-to-use prompt.

Example prompts

List my Power BI workspaces and the reports in each one.

The alternative to ClawLink is usually manual OAuth app setup plus your own token handling, permission troubleshooting, and tool plumbing for Hermes Agent. That is fine if you want to build and maintain the integration yourself. Most teams just want Power BI working from chat.

ManualClawLink
Connection flowRegister a Power BI app, configure redirect URLs, manage consent details, and reconnect users when auth settings drift.Users connect Power BI through the hosted browser flow and ClawLink keeps the token lifecycle out of your app code.
Ongoing maintenanceYou own refresh logic, permission debugging, environment config, and every provider-specific edge case for Power BI.ClawLink handles the repetitive integration plumbing so your team can focus on the workflow instead of the infrastructure.
Agent usabilityYou still need to expose the right Power BI actions to the runtime in a format your agent can reliably use.277 tools for Power BI are already exposed through ClawLink, so the agent can read and act from chat immediately.

Composio also exposes Power BI to AI agents. It is developer infrastructure: Python and TypeScript SDKs, an MCP server, and a catalog past 1,000 apps, aimed at teams shipping agent products. ClawLink is built for Hermes Agent users instead. You install the plugin once, connect Power BI in the browser, and the 277 tools above work from chat. There is no SDK, no config file, and no API key handling. Choosing between them? Read the full Composio alternatives comparison.

Troubleshooting

Hermes paired but still can't use Power BI

Pairing is a two-step handshake: run hermes clawlink begin, approve the link in your browser, then run hermes clawlink finish. If you ran finish before approving, or the approval link expired, run hermes clawlink begin again to get a fresh link. Confirm the plugin was installed with --enable, then verify with hermes clawlink test.

Connection succeeds but no tools appear

Reconnect Power BI from the dashboard, then start a fresh chat if the runtime still has the old tool catalog loaded.

"Tool schema not loaded yet" error when calling Power BI tools

Power BI tool schemas load on demand the first time a tool runs and are cached after that, so this error usually clears on its own: wait a few seconds and retry the same request. If every Power BI call keeps failing with it in a fresh chat, reconnect from the dashboard, and contact support if it still persists — that pattern points to a configuration problem on our side, not something you can fix by reconnecting again.

Power BI returns 403 or "permission denied" on one action while others work

Two usual causes. The connected account may not have access to the specific workspace, inbox, store, or project in the request — check that first. If access looks right, the agent may have sent a placeholder value (like "YOUR_ID" or an example id from documentation) instead of a real one: ask it to run a list or search tool first, then retry the action with a real id from those results. Most failures at this stage are one of these two, not ClawLink bugs.

Need admin approval

Your organization blocks you from approving new apps yourself. ClawLink's Microsoft app is not publisher-verified yet, and many organizations only let an IT admin approve apps like that. Ask your IT admin to approve ClawLink once for the organization, then connect Power BI again.

OAuth finished in the browser but the account is still missing

Try reconnecting Power BI and complete the consent flow in the same browser session. Partial OAuth approvals or switching accounts mid-flow can leave the connection incomplete.

FAQ

Is there a Hermes Agent Power BI integration?

Yes. ClawLink is the fastest way to connect Hermes to Power BI: link your Power BI account once in the browser and Hermes Agent can call the Power BI API through 277 ready-made tools — no custom code or token handling.

How do I connect Power BI to Hermes with ClawLink?

Install the plugin with hermes plugins install ClawLink-HQ/hermes-plugin --enable, then pair once: run hermes clawlink begin, approve the link in your browser, and run hermes clawlink finish. Connect Power BI in the dashboard and Hermes can use it from the next message — no config files or API keys to manage.

How long does it take to connect Power BI to Hermes Agent?

About two minutes. Sign in, click Connect next to Power BI in the dashboard, authenticate, and Hermes Agent can use it from the next chat message.

Why use ClawLink instead of wiring Power BI up myself?

The alternative to ClawLink is usually manual OAuth app setup plus your own token handling, permission troubleshooting, and tool plumbing for Hermes Agent. That is fine if you want to build and maintain the integration yourself. Most teams just want Power BI working from chat.

Can I connect Power BI with a personal Microsoft account?

No. Power BI signs in only with a work or school Microsoft account, so an Outlook.com, Hotmail or Live account cannot connect. Use the account you sign in to app.powerbi.com with.

Hermes paired but still can't use Power BI

Pairing is a two-step handshake: run hermes clawlink begin, approve the link in your browser, then run hermes clawlink finish. If you ran finish before approving, or the approval link expired, run hermes clawlink begin again to get a fresh link. Confirm the plugin was installed with --enable, then verify with hermes clawlink test.

On this page