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.