Hello everyone,
I have a problem with some Microsoft Graph connectors that I have configured to be used as a knowledge source for my agents.
In the Microsoft Admin Center, I have configured the connector for Microsoft Sql Server. I have installed the Graph Connector agent on the SQL Server and registered it with an Entra Application with the following API permissions:
- User.Read (delegate)
- Directory.Read.All (application)
- ExternalConnection.ReadWrite.OwnedBy (application)
- ExternalItem.ReadWrite.OwnedBy (application)
In the Admin Center I have configured it to use that Graph Connector Agent, entered a database and a statement (with watermark). I have configured the schema so some properties are queryable, some are searchable and all are retrievable, and I have added semantic labels where applicable. It has indexed all the items from the table that I picked, I have added it to a vertical and I have access to the data in Microsoft Search using the same account I use for Copilot Studio.
I can add the connector as a knowledge source, however, when I prompt the agent to deliver me data from that connection, I don't get any results, just the standard "I'm sorry, I'm not sure how to help with that. Can you try rephrasing?". The connector has the correct name and description, and the items have definitely been indexed. This shouldn't be a problem with the ACL, since I have granted the access to the data to everyone in the organization. The database content is in German though, so maybe that is causing trouble?
I have the same problem with 2 other custom connectors, where the data is also properly indexed, and I can access it in Microsoft Search, but apparently the agent can't access it as a knowledge source.
Notably, the agent does have access to the data in the FileShare connector I configured in the same way, with the same permissions, so I wonder why that one works and the other ones don't...
Help would be appreciated, thanks!
