Fabric data agent

[Shiyao]

I created a Fabric data agent and connected it as a knowledge source via Azure AI Foundry agent. I also developed a custom python application and run the Azure AI Foundry agent. But the run info of the agent only shows input and output (with some obfuscated tags like【92:0†source】) of the connected Fabric data agent, not the SQL query code it uses in response. Is it possible to fetch this SQL query Fabric data agent generates within agent run via Azure AI Projects Python SDK.

[v-agajavelly]

Hi @Shiyao 

Based on the latest documentation and updates, the Fabric Data Agent Python SDK does allow for programmatic interaction with data agents, including evaluation and inspection of responses. However, it does not currently expose the raw SQL queries generated by the Fabric data agent during a run via the Azure AI Projects Python SDK.

The obfuscated tags like 【92:0†source】 are part of the internal referencing system used to trace back to the knowledge source, but they don’t reveal the actual SQL logic used behind the scenes.

You can, evaluate agent responses using structured test sets. Retrieve detailed logs and evaluation summaries and customize evaluation prompts to judge answer quality.

For official guidance, check out.

• Fabric Data Agent SDK documentation on Microsoft Learn
• Evaluation walkthrough on the Microsoft Fabric Blog
• SDK package details on PyPI

If you're aiming to debug or audit the SQL logic, your best bet might be to use a custom critic prompt during evaluation that asks the agent to explain its reasoning or inferred query logic.
------------------------------------------------------------------------------------------------------------------------------
If this solution works for you, please consider marking it as accepted so others facing a similar issue can benefit too.

Regards,
Akhil.