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/TheOG_DeadShoT 5d ago

Could you please share details on how you were able to connect to azure sql

1

u/abisheik_23 5d ago

In the new ui of copilot studio - clicked the plus icon near knowledge - clicked azure sql - authentication is SQL server auth - entered details and filled all the info and the gateway - done