I have successfully linked and added my azure SQL database as knowledge to my copilot agent.
But when i am asking the agent any query related to the database. it doesnt use my connected database.
It gets the response generated from general knowledge, and it doesnt search over the sql database connected.
My SQL connection status is connected and its showing ready in the knowledge section.
If anyone has any idea what might be the issue, or can help me to find an alternative to using sql database via azure search AI, I would really appreciate it.
Alternatively I have also tried using Azure AI search, I have made a index and when using it I am getting an error msg such as Unsupported indexesSome of your indexes are unsupported because they don't use integrated vectorization.
If anyone has any idea, I would really appreciate the help/answer.
I would recommend using the SQL Server connector as a Tool instead of adding your SQL database as a Knowledge source.
Knowledge sources in Copilot Studio are meant for unstructured data (documents, websites, or Azure AI Search indexes). They don’t actually execute SQL queries, they only perform semantic text searches.
Have you already tried setting it up that way?
2 people found this reply helpful.
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.