# How to connect Power BI to Hermes Agent (no API keys) > Connect Power BI to Hermes with ClawLink in one click — 114 tools your AI agent can call from chat via hosted OAuth. No API keys, no manual setup. Web version: https://claw-link.dev/hermes/power-bi 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. **Install ClawLink** — add the plugin to Hermes Agent once. 2. **Connect Power BI** — one-click OAuth in the ClawLink dashboard. 3. **Use it from chat** — ask Hermes Agent in plain English. **Paste this into Hermes to set up ClawLink:** > Set up ClawLink for Hermes and tell me when it's ready. > 1. Install the plugin: `hermes plugins install ClawLink-HQ/hermes-plugin --enable` > 2. Start pairing with `hermes clawlink begin`. It prints an approval link, so show me the link and stop, don't wait. > 3. I'll approve it in my browser, then reply "approved". > 4. When I say approved, finish setup: `hermes clawlink finish` > 5. Then run `hermes clawlink test` and tell me whether ClawLink is ready. **Alternative for any agent (no plugin needed):** if the Hermes Agent plugin route isn't available or doesn't work, any AI agent with shell access can use the ClawLink CLI instead: ```bash npx -y @useclawlink/cli login # sign in via browser — no API key to paste npx -y @useclawlink/cli connect power-bi # connect Power BI (browser OAuth) npx -y @useclawlink/cli actions power-bi # list available actions npx -y @useclawlink/cli run power-bi --input '' # execute (add --confirm for writes) ``` ### Install by command The prompt above walks Hermes through this. By hand, it is four commands and a browser approval: ```bash 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](https://claw-link.dev/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: ```bash 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 114 Power BI tools over MCP. Full setup for MCP clients and shell agents: [connect apps to any AI agent](https://claw-link.dev/learn/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 114 Power BI tools your agent can call over [MCP](https://claw-link.dev/learn/what-is-an-mcp-server), with [hosted auth](https://claw-link.dev/learn/oauth-for-ai-agents) and nothing to run or maintain yourself. Using OpenClaw instead? The [OpenClaw Power BI integration](https://claw-link.dev/openclaw/power-bi) works the same way. ## What the Hermes Agent Power BI integration can do 114 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 114. ### 30 of 114 Power BI tools for Hermes | Tool | What it does | |---|---| | **Microsoft power bi apps get reports** `microsoft_power_bi_apps_get_reports` | Returns a list of reports from the specified app | | **Microsoft power bi discover gateways** `microsoft_power_bi_discover_gateways` | Returns a list of gateways that the specified dataset from the specified workspace can be bound | | **Microsoft power bi execute dax queries** `microsoft_power_bi_execute_dax_queries` | Executes Data Analysis Expressions (DAX) queries against the provided dataset in My workspace | | **Microsoft power bi execute queries 2** `microsoft_power_bi_execute_queries_2` | Executes Data Analysis Expressions (DAX) queries against the specified Power BI dataset | | **Microsoft power bi get available feature by name** `microsoft_power_bi_get_available_feature_by_name` | Returns the specified available feature for the user by name | | **Microsoft power bi get capacities** `microsoft_power_bi_get_capacities` | Returns a list of Power BI capacities that the authenticated user has access to | | **Microsoft power bi get dashboard2** `microsoft_power_bi_get_dashboard2` | Returns the specified dashboard from My workspace | | **Microsoft power bi get dashboards** `microsoft_power_bi_get_dashboards` | Returns a list of dashboards from the specified workspace | | **Microsoft power bi get data set data** `microsoft_power_bi_get_data_set_data` | Gets the query results for the specified DataSet | | **Microsoft power bi get data sets** `microsoft_power_bi_get_data_sets` | Gets an array of DataSet CatalogItems from Power BI | | **Microsoft power bi get dataflows** `microsoft_power_bi_get_dataflows` | Returns a list of all dataflows from the specified workspace | | **Microsoft power bi get dataset** `microsoft_power_bi_get_dataset` | Returns the specified dataset from My workspace | | **Microsoft power bi get dataset to dataflows links** `microsoft_power_bi_get_dataset_to_dataflows_links` | Returns a list of upstream dataflows for datasets from the specified workspace | | **Microsoft power bi get dataset users** `microsoft_power_bi_get_dataset_users` | Returns a list of principals that have access to the specified dataset | | **Microsoft power bi get dataset users in group** `microsoft_power_bi_get_dataset_users_in_group` | Returns a list of principals that have access to the specified dataset within a workspace | | **Microsoft power bi get dataset2** `microsoft_power_bi_get_dataset2` | Returns the specified dataset from the specified workspace | | **Microsoft power bi get datasets** `microsoft_power_bi_get_datasets` | Returns a list of datasets from My workspace | | **Microsoft power bi get datasources** `microsoft_power_bi_get_datasources` | Returns a list of data sources for the specified dataset from My workspace | | **Microsoft power bi get datasources in group3** `microsoft_power_bi_get_datasources_in_group3` | Returns a list of data sources for the specified dataset from the specified workspace | | **Microsoft power bi get gateway** `microsoft_power_bi_get_gateway` | Returns the specified gateway | | **Microsoft power bi get gateway datasources in group** `microsoft_power_bi_get_gateway_datasources_in_group` | Returns a list of gateway data sources for the specified dataset from the specified workspace | | **Microsoft power bi get gateways** `microsoft_power_bi_get_gateways` | Returns a list of gateways for which the user is an admin | | **Microsoft power bi get goal value by ID** `microsoft_power_bi_get_goal_value_by_id` | Reads a goal value check-in by a UTC date timestamp | | **Microsoft power bi get goals** `microsoft_power_bi_get_goals` | Returns a list of goals from a scorecard | | **Microsoft power bi get goals refresh history** `microsoft_power_bi_get_goals_refresh_history` | Reads refresh history of a connected goal | | **Microsoft power bi get goals status rules** `microsoft_power_bi_get_goals_status_rules` | Returns status rules of a goal | | **Microsoft power bi get group users** `microsoft_power_bi_get_group_users` | Returns a list of users that have access to the specified workspace | | **Microsoft power bi get groups** `microsoft_power_bi_get_groups` | Returns a list of workspaces the user has access to | | **Microsoft power bi get groups capacity assignment status** `microsoft_power_bi_get_groups_capacity_assignment_status` | Gets the status of the assignment-to-capacity operation for the specified workspace | | **Microsoft power bi get import** `microsoft_power_bi_get_import` | Returns the specified import from My workspace | ## Example prompts **List workspaces and reports** > List my Power BI workspaces and the reports in each one. **Run a DAX query** > Run a DAX query on my Sales dataset that returns the 10 largest orders by amount. **Refresh a dataset** > Refresh the Sales dataset, then check the refresh history and tell me if it finished. **Read a dashboard** > Which dashboards are in the Finance workspace, and what tiles does each one show? ## ClawLink vs. building it yourself 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. | | Manual | ClawLink | |---|---|---| | **Connection flow** | Register 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 maintenance** | You 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 usability** | You still need to expose the right Power BI actions to the runtime in a format your agent can reliably use. | 114 tools for Power BI are already exposed through ClawLink, so the agent can read and act from chat immediately. | ## ClawLink vs. Composio 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 114 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](https://claw-link.dev/hub/composio-alternatives) comparison. ### 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. ### 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 114 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`. ## Related - [Outlook](https://claw-link.dev/hermes/outlook) — Read mail, manage calendar, and browse contacts - [Connect Microsoft Teams](https://claw-link.dev/hermes/microsoft-teams) — Chat, meetings, and team collaboration - [SharePoint tools](https://claw-link.dev/hermes/sharepoint) — Browse sites, lists, and files in SharePoint