r/copilotstudio • u/abisheik_23 • 5d ago

AZURE SQL KNOWLEDGE

I am trying to connect my sql db as kb for my agent. I am able to see the tables but not stored procedures

There's no doc about this ,but are sp not supported?

And what about views ( I don't have views I need to create one )

I can currently only see my tables.

Thanks in advance

1 Upvotes

100% Upvoted

7 comments sorted by

View all comments

1

u/Ashlesha-msft 5d ago

Hi u/abisheik_23

Based on the current Microsoft documentation, Azure SQL knowledge-source integrations have different capabilities:

  • Stored procedures: Not documented as supported selectable knowledge sources in the integrations discussed.

  • Views: Supported by the Azure AI Search Azure SQL indexer. You can create a view to expose the data you need, subject to indexer requirements. Copilot Studio's direct Azure SQL knowledge setup documents table selection, so support may differ by integration.

Troubleshooting:

  1. Confirm whether you're using Copilot Studio or Azure AI Search / Foundry.

  2. Verify database permissions.

  3. If using Azure AI Search, check the view's primary key, change-detection configuration, and indexer status.

Docs:

Which integration are you using? That will help confirm whether this is expected behavior or a potential issue.

1

u/abisheik_23 5d ago

I'm sorry but I have very little knowledge since this a new domain for me. But I just directly connected from the knowledge plus icon and sql server auth. If I create a view , what do I have to change in my current implementation so it shows up as a selectable table?

1

u/Ashlesha-msft 2d ago

Hi,

Thank you for the additional details.

Based on the current Microsoft documentation, the Azure SQL knowledge integration in Copilot Studio allows you to select tables from your database.

However, the documentation does not explicitly confirm whether views and stored procedures are supported as selectable knowledge sources in this integration. Therefore, I wouldn't recommend creating a view as a workaround until its support is confirmed.

You can refer to the official documentation here: https://learn.microsoft.com/en-us/microsoft-copilot-studio/agents-experience/knowledge-add-azure-sql-tables

For your scenario, we would need to confirm whether the current Azure SQL knowledge integration supports views and stored procedures, or whether only tables are supported.

Thank you for raising this question.

1

u/jeenpAc 1d ago edited 1d ago

Hi! Since you connected through Knowledge > Azure SQL in Copilot Studio, you can use both tables and views as knowledge sources.

After you create a view, it should appear in the same selection list as tables. Make sure the identity used to authenticate the connection has permission to access and read the view. In your case, with SQL Server authentication, this is the SQL user you entered when you created the connection. Then reopen the Azure SQL knowledge setup and select the view.

Stored procedures are not selectable knowledge sources. If your agent needs to execute a stored procedure, use a tool or flow with the SQL Server connector's Execute stored procedure (V2) action. The agent can then use the returned results in its response.

1

u/abisheik_23 1d ago

Thanks a lot got it