Unanswered

SQL Table(s) as Knowledge source - SQL Connector

(0) Share

Report

Posted on by WD-26111639-0

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:

General topics

I have the same question (0)

All responses (3)

Answers (0)

Sort by

SaiRT14 1,992 Super User 2025 Season 1 on at

Like (0)

Report
Copy link

Link copied!

The Copilot agent relies on proper database indexing and query structure to fetch results effectively. create index and retry

Was this reply helpful? Yes No
WD-26111639-0 4 on at

Like (0)

Report
Copy link

Link copied!

Just added an index, but that does not help at all. No results. Not sure what I can do about the query structure.

Was this reply helpful? Yes No
CU09121125-0 2 on at

Like (0)

Report
Copy link

Link copied!

Any update on this one? I am also having same issue.

Was this reply helpful? Yes No