Forum Discussion
An agent that converses with Fabric Warehouse data using natural language.
I'm trying to create an agent that uses Microsoft Foundry to converse with data in a Microsoft Fabric warehouse using natural language. Initially, I tried using Azure AI Search as a tool, but it ...
Please follow these steps; it might solve your issue:
- create fabric agent of top of your warehouse
- Publish the Fabric Data Agent
- Create an agent in Azure AI Foundry
- Connect the Fabric Data Agent as a tool
- As simple Explicit instructions to your agent
- When the user asks questions about business data, metrics, reports, or numbers, use the Fabric Data Agent.
OR you can create your own MCP server
. Please see the following links for reference
https://learn.microsoft.com/en-us/azure/foundry/agents/how-to/tools/fabric
https://learn.microsoft.com/en-us/fabric/data-science/concept-data-agent
https://learn.microsoft.com/en-us/azure/data-api-builder/mcp/quickstart-azure-ai-foundry