Connect Power BI to Goose
Give Goose governed access to Power BI’s 4 tools through Runlayer, with identity, policy, scanning, and audit on every call.
Set up
Add Power BI to Goose in four steps
Admins approve the server once. Everyone in Goose then gets it through the same governed connection.
- 1
Add Power BI to Runlayer
Power BI isn’t in the Runlayer catalog yet, so an admin adds it by its MCP server URL.
Adding a connector manually - 2
Connect Goose to Runlayer
Users add the Runlayer Plugin as a Goose extension; Goose has no native plugin install. Goose reaches Power BI’s 4 tools through the Runlayer Plugin’s search and execute tools instead of listing each one.
Goose setup guide - 3
Sign in to Power BI
Sign in the way Power BI requires. Runlayer holds the credentials so they stay out of the client’s configuration.
- 4
Use Power BI from Goose
Power BI’s approved tools appear in Goose. Every call is checked against policy and recorded.
Tools
4 Power BI tools in Goose
Runlayer policy decides which of these Goose users can call.
Execute query
Executes a DAX query and return the results.
Generate query
Generates a DAX query using the relevant parts of the model schema.
Get report metadata
Retrieves the high-level schema of a Power BI report, including workspace information, semantic model details, pages, visual information, and filters.
Get semantic model schema
Retrieves comprehensive metadata for a specified semantic model, including the serialized schema, custom instructions provided by the model author, and verified answers when available.
Control
What Runlayer can see and stop in Goose
Some controls apply to every client at the gateway. Others depend on what Goose exposes to Runlayer.
Gateway policy (available)
Every Power BI call from Goose passes through Runlayer, where your policies can allow, alert, mask, or block it.
Audit trail (available)
Each call is recorded with the user, Goose as the client, the tool, and the policy and scanner decisions.
Client hooks (available)
Capture supported prompts, reasoning, local and MCP tool calls, responses, and scanner decisions in real time.
Stop a call before it runs (available)
Runlayer can deny a tool call before Goose runs it.
Block output after it runs (available)
Runlayer can block a tool’s output before Goose’s model sees it.
Redact output in place (not available)
Goose cannot apply masking, so Runlayer blocks output it would otherwise mask. The gateway still applies policy to the call.
Frequently asked questions
Connect more