Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
This article explains how to set up and use the Microsoft Dataverse model context protocol (MCP) server with Microsoft Copilot Studio. By following the steps in this article, you can interact with Dataverse, asking natural language questions like show me my contacts and receive answers based on stored data.
Prerequisites
- The Microsoft Copilot Studio MCP client must be allowed in the environment. More information: Configure and manage the Dataverse MCP server for an environment
Connect to Dataverse using an MCP server in Microsoft Copilot Studio
- Go to Power App and select your environment from the top right environment selector.
- From the left navigation pane, select Agents > Create new agent. If the item isn’t in the side panel pane, select …More and then select the item you want.
- Select Create.
- Scroll down to the Tools section and select + Add tool.
- Select Model Context Protocol, and then select Dataverse MCP Server.
- If there's no existing Dataverse connection, you're prompted to connect one.
- Select Add to agent.
The individual tools available on this MCP server can be viewed and modified by selecting ... > Edit next to the Dataverse MCP Server tool.
You can now interact with the Dataverse MCP Server tool in the Test your agent chat pane. Try commands like "list tables in Dataverse," "describe table account," or "how many accounts do I have."
