This blog was co-authored by Toussaint Webb, Databricks
We’re excited to announce the Public Preview availability of AI/BI Genie in Microsoft Copilot Studio and Microsoft Foundry via MCP. This makes it easier than ever for organizations to unlock and scale the power of their Genie spaces across the Microsoft ecosystem (e.g., Teams), ultimately democratizing trusted data and insights to business users.
AI/BI Genie opens the power of conversational analytics to everyone in the organization. A user can ask a question such as “What is my revenue growth this month?” and Genie interprets the intent, generates the appropriate query, and returns the data insight. Users can also review the underlying logic for transparency. By supporting iterative questioning, Genie enables users to investigate their data directly and build confidence in their understanding without requiring code or specialist intervention.
The Challenge Before: Complex setup via Custom Code
Previously, connecting Genie to the Microsoft ecosystem was challenging. Organizations had to develop custom connections to manage API flows, which added architectural overhead. This complexity limited organizations’ ability to distribute Genie’s trusted insights efficiently across Microsoft platforms.
What’s Now Possible: Unlock the value of Microsoft Ecosystem
The new integrations between Genie and Copilot Studio, as well as Genie and Microsoft Foundry, solve these challenges by providing easy and secure ways to connect each platform. Additionally, by leveraging MCP, updates to the underlying Genie APIs are seamlessly managed for users, eliminating the need to modify your integration.
Genie + Copilot Studio
- Connect a Genie space to a Copilot Studio Agent as a tool (over MCP)
- Instantly make Genie’s trusted insights available in Teams or M365 Copilot by publishing Genie enabled Copilot Studio agents
- Genie’s complete context of a customer’s data estate will enable Copilot Studio agents to deliver richer, more accurate responses
Genie + Microsoft Foundry
- Connect a Genie space to Foundry as a tool (over MCP)
- Instantly make Genie’s trusted insights available to developers building agents using Foundry
How It Works: Genie + Copilot Studio
- Create a connection to your Azure Databricks workspace in Power Apps, using OAuth or a Microsoft Entra ID Service Principal
- Open Copilot Studio
- Select an existing Copilot Studio agent or create a new one
- Open ‘Tools’, click ‘+Add a tool’, and search for “Azure Databricks Genie” or find it within the Model Context Protocol section
- Select the Genie space to connect and configure the connection
Note: It’s important to give your Genie space a clear title and description so the Copilot Studio agent can effectively orchestrate requests.
After completing the steps above, you are ready to go and can publish the agent to channels, such as Microsoft Teams, to easily distribute the value of Genie to your organization.
How It Works: Genie + Microsoft Foundry Portal
- Open Microsoft Foundry
- Go to the tool catalog within the Discover tab
- Select ‘Azure Databricks Genie’
- Configure the connection your Azure Databricks Genie space and click ‘Connect’
- Click ‘Use in an agent’ and select the desired agent to connect your Genie space to
Once completed, Genie is available for use in your Foundry agent!
Try It Out: Get started with Genie in Copilot Studio and Microsoft Foundry
- To get started with Genie + Copilot Studio, check out our technical documentation
- To get started with Genie + Microsoft Foundry, check out the documentation
- To learn more about the Generally Available Azure Databricks Power Platform connector explore this blog
Microsoft