Power Platform Community Forum Thread Details

Copilot Studio not giving response after publishing from knowledge source as sql server

I have built a bot in Microsoft Copilot Studio that uses an Azure SQL Database table (connected via on prem gateway) as its knowledge source. The bot is fully functional in test mode when used within the Copilot Studio interface using the default Teams authentication (Authenticate with Microsoft). However, when I publish the bot externally on a website and set up manual authentication via Azure AD, the bot fails to retrieve responses from the SQL knowledge source and instead replies with:

"I am sorry, can you try rephrasing?"

This happens despite the fact that:
✅ The bot correctly authenticates using Azure AD on the external website.
✅ The same query works in test mode inside Copilot Studio (with Microsoft authentication).
✅ No authentication errors appear in the logs.
✅ The manual authentication settings include the necessary API permissions, including:

ExternalItem.Read.All
profile
openid

What I Have Tried

Tested the bot inside Copilot Studio using the default Microsoft authentication (Teams) → Works fine.
Checked authentication settings for external website → The bot is correctly authenticated and running.
Verified Azure AD API permissions:
- Added ExternalItem.Read.All alongside profile and openid.
- Ensured that the permissions are correctly consented to
  
  still this issue persists
  
  If anyone has faced a similar issue or has insight into how authentication affects knowledge source access, please share any troubleshooting steps or solutions. Thank you in advance!