Fabric Data Agents

Hi ali_lmalki,

Fabric Data Agents do have an orchestrator/routing layer that decides which data source to use.

The current Microsoft documentation describes the process roughly as:

1. The orchestrator creates a plan for the user's question.
2. It evaluates the metadata of the available sources — including source name, description, selected schema, and example queries.
3. It selects the source most likely to answer the question.
4. It invokes the appropriate query-generation tool (NL2SQL, NL2DAX, NL2KQL, etc.).
5. If the question is ambiguous, it can inspect more of the source schema and potentially use another source.

So it isn't simply matching the user's question against a static list of instructions. 

A useful detail is that you can inspect the run steps after an answer to see which source was selected and what metadata influenced the routing decision. This is probably the best way to understand what the agent is doing in practice.

Find here some official docs which can help for details:

Data agent configurations - Microsoft Fabric | Microsoft Learn

Improve data source routing - Microsoft Fabric | Microsoft Learn

Hope this helps, if so, consider leaving kudos or mark it as solution.

Best regards!