Connect Looker to Microsoft 365 Copilot
Give Microsoft 365 Copilot governed access to Looker’s 30 tools through Runlayer, with identity, policy, scanning, and audit on every call.
Set up
Add Looker to Microsoft 365 Copilot in four steps
Admins approve the server once. Everyone in Microsoft 365 Copilot then gets it through the same governed connection.
- 1
Approve Looker in Runlayer
Add Looker from the catalog and choose who can use it and which of its tools are allowed.
- 2
Connect Microsoft 365 Copilot to Runlayer
Users add the Runlayer Plugin to Microsoft 365 Copilot by following Runlayer’s setup guide. Microsoft 365 Copilot reaches Looker’s 30 tools through the Runlayer Plugin’s search and execute tools instead of listing each one.
Microsoft 365 Copilot setup guide - 3
Sign in to Looker
Each user signs in to Looker with OAuth. Runlayer keeps the tokens out of the client’s configuration.
- 4
Use Looker from Microsoft 365 Copilot
Looker’s approved tools appear in Microsoft 365 Copilot. Every call is checked against policy and recorded.
Tools
30 Looker tools in Microsoft 365 Copilot
Runlayer policy decides which of these Microsoft 365 Copilot users can call.
Dev mode
Allows toggling the Looker IDE session between Development Mode and Production Mode.
Generate embed URL
Generates a signed, private embed URL for specific Looker content, allowing users to access it directly.
Get connection databases
Retrieves a list of databases available through a specified Looker connection.
Get connection schemas
Retrieves a list of database schemas available through a specified Looker connection.
Get connection table columns
Retrieves a list of columns for one or more specified tables within a given database schema and connection.
Get connection tables
Retrieves a list of tables available within a specified database schema through a Looker connection.
Get connections
Retrieves a list of all database connections configured in the Looker system.
Get dashboards
Searches for saved dashboards in a Looker instance.
Control
What Runlayer can see and stop in Microsoft 365 Copilot
Some controls apply to every client at the gateway. Others depend on what Microsoft 365 Copilot exposes to Runlayer.
Gateway policy (available)
Every Looker call from Microsoft 365 Copilot passes through Runlayer, where your policies can allow, alert, mask, or block it.
Audit trail (available)
Each call is recorded with the user, Microsoft 365 Copilot as the client, the tool, and the policy and scanner decisions.
Managed browser extension (available)
Managed Chrome, Edge, and Firefox deployments can monitor supported web-chat activity and apply prompt-time controls where the surface permits it.
Native enforcement adapter (not available)
Runlayer has no device-side adapter for Microsoft 365 Copilot yet, so control happens at the gateway.
Frequently asked questions
Connect more
