Copilot Studio – Azure SQL Knowledge Source Connected but Agent Cannot Retrieve Data

Question

Dear reader,

I'm integrating an Azure SQL Database as a knowledge source in Copilot Studio, but despite the connection showing as successful and preview data being visible, the agent is unable to retrieve any data when queried. Below are the details and context of our setup.

Knowledge Source:

• Type: Azure SQL Database
• Connection status: Successful – preview data is visible inside Copilot Studio.

Although the data source is connected successfully and preview data displays correctly, when we query the agent with questions it doesn't seem to make a valid connection.

It is shown that it tries to read the table three times, but all time-out after almost exactly 60 seconds. Then the LLM simply responses with a generic answer without any connected knowledge.

After the response, we can see that it did know to search through the table, but it shows a red exclamation mark with text on hover saying 'Request time-out occured. Dataverse Knowledge Search API call timed out'

The following settings are disabled:

• Web Search
• Content Generation

I know there is a similar question on this forum (https://learn.microsoft.com/en-us/answers/questions/5643897/copilot-studio-azure-sql-knowledge-source-connecte), but that didn't yield any solution whatsoever.

What causes this problem? And how should I approach it?