Forum Discussion

yy's avatar
yy
Copper Contributor
Mar 18, 2026

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 didn't work due to the 1000-item index limit.

 

I suspect there might be a way to access the warehouse directly without using Azure AI Search, but I don't know how.

 

Could you please tell me how to implement this?

 

Thank you in advance.

1 Reply

  • Imran Shakeel's avatar
    Imran Shakeel
    Copper Contributor
    Mar 29, 2026

    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