Skip to main content

Notifications

Copilot Studio - General
Unanswered

SQL Table(s) as Knowledge source - SQL Connector

Posted on 26 Nov 2024 16:42:49 by
Trying to build an agent with knowledge coming from an SQL (Azure) database. But, whatever I do (including defining synonyms) the agent won't fetch any data nor results from the table(s). Only getting 'No information was found that could help answer this.'. Connections look fine, Knowledge shows 'ready'.  ALreadt tried in two different environments.  When I import a table in the Dataverse, then the agent is using the data, but not from SQL Azure. What am I doing wrong?
Categories:

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.

Helpful resources

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,129

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,797

Leaderboard