Microsoft 365
Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line.
5,673 questions
How to Enable Copilot Agent to Query Large Datasets from SQL?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(310.4, 22%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZA%3C/text%3E%3C/svg%3E)
Zuha Alfaraj
0
Reputation points
Hello,
I'm using SQL tables from a Synapse Dedicated Pool as a knowledge source in a Copilot agent. The datasets are quite large, but I've noticed that the Copilot agent only queries up to 2,048 rows (tested across multiple tables).
How can I configure my Copilot agent to query the entire dataset and generate accurate responses?
Note: The data is structured (row-based), which is why I’m not considering Azure AI Search for this scenario.
Any insights or recommendations would be greatly appreciated!
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(160, 48%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
Sayali-MSFT 3,371 Reputation points Microsoft Vendor2025-01-30T07:16:24.4266667+00:00 @Zuha Alfaraj, Thank you for your inquiry! Could you please provide more details about your issue? Specifically, it would be helpful to know:
Reproduction Steps: What steps did you take leading up to the problem?
Documentation Links: Are there any specific guides or documentation you followed?
Teams Client Version: What version of the Teams client are you using?
- Code Snippets: If applicable, please share any relevant code snippets.
Providing this information will help us better understand your situation and assist you more effectively
-
Zuha Alfaraj 0 Reputation points
2025-01-30T15:25:48.1133333+00:00 @Sayali-MSFT Thank you for your response
Reproduction Steps:
- Create a Copilot Agent
- Add SQL connection as a knowledge source
Documentation Links:
https://learn.microsoft.com/en-us/microsoft-copilot-studio/knowledge-graph-connections
Teams Client Version
The client version is 49/24120100221.
-
Sayali-MSFT 3,371 Reputation points Microsoft Vendor
2025-02-04T10:26:27.7533333+00:00 @Zuha Alfaraj, Thanks for sharing the information. We will check this with internal team and let you know the update.
Sign in to comment
Sign in to answer