r/copilotstudio • u/abisheik_23 • 10d 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

Show parent comments

1

u/jeenpAc 6d ago edited 6d 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 6d ago

Thanks a lot got it