
Hi Team,
I’m using Azure SQL Server as a data source in Microsoft Copilot Studio. When I ask natural language questions in the Copilot, it provides correct answers based on my database — which indicates it is firing SQL queries in the background.
However, I’m unable to trace or view the actual SQL queries that Copilot Studio is generating and executing against the Azure SQL Database.
I would like to know:
Where can I find the query logs or traces of the SQL statements Copilot sends to the database?
Is there any built-in option or diagnostic setting in Copilot Studio, Power Automate, or Azure SQL that allows capturing or monitoring those generated queries?
If not, what is the recommended way to audit or debug** the queries executed by Copilot Studio for transparency and troubleshooting.
I’m also attaching an activity snapshot for reference.
Any guidance or documentation link would be greatly appreciated.
Thanks & Regards,
Srujan V