Microsoft Copilot Studio

Build Copilot Studio agents that can find trustworthy data, trace lineage, look up ownership, and answer data questions grounded in your enterprise context from DataHub.

Prerequisites

• A Microsoft Copilot Studio account
• A DataHub Cloud instance (v0.3.12+) or self-hosted DataHub with the MCP server running
• A DataHub personal access token

Setup

1. Create or Open an Agent

In Copilot Studio, click + Create a blank agent or open an existing one.

<p align="center"> </p>

2. Add an MCP Tool

From your agent's overview, scroll to Tools and click + Add tool. Select Model Context Protocol under "Create new".

<p align="center"> </p>

3. Configure the MCP Connection

Field	Value
Server name	DataHub MCP Server
Server URL	https://<tenant>.acryl.io/integrations/ai/mcp
Authentication	API key · Header · Authorization · Bearer <token>

<p align="center"> </p>

:::note Self-Hosted DataHub For self-hosted instances, expose the MCP server via a publicly accessible URL and use that as the Server URL. :::

4. Enable Tools

Click Next — Copilot Studio discovers DataHub's tools automatically. Click Add and configure, then toggle on the tools you want.

<p align="center"> </p>

5. Test

Click Test in the top-right corner and try:

• "What datasets does the analytics team own?"
• "Show me the lineage for the revenue dashboard"

<p align="center"> </p>

Tips

• Use the Instructions field to guide behavior — e.g., "Always search DataHub before answering data questions."
• Publish your agent to Teams, your website, or other channels when ready.

Troubleshooting

• Can't connect? Verify the DataHub URL, check the token hasn't expired, and confirm auth is set to API key (not OAuth). Include the Bearer prefix.
• Tools not appearing? Click refresh on the Tools page. Verify the MCP server is running and the token has the right permissions.
• Empty results? Check that your DataHub instance has ingested metadata. Try broader search terms.

Links: Copilot Studio Docs · Agent Context Kit · MCP Server Guide