web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Copilot Studio - Bot Extensibility
Unanswered

Error when adding Azure SQL as knowledgebase

(1) ShareShare
ReportReport
Posted on by 20
Hi everyone!
 
I am having troubles when trying to add Azure SQL database as knowledgebase in my custom copilot.
 
I am successfully connecting to my database and I could see all my tables in it. But for some reason I am unable to preview them, I get the below error message:
 
"Something went wrong. Try reloading the page. If the problem persists, contact your admin. Session Id: **********"
 
Also, when I add a table as knowledgebase, it tries to load it for about couple of minutes and then shows "Error" on the status field.
 
I kind of feel like this is a permissions issue.
 
Has anyone had such an experience?
 
Many thanks!
 
 
Categories:
I have the same question (0)
  • Michael E. Gernaey Profile Picture
    50,271 Super User 2025 Season 2 on at
    Error when adding Azure SQL as knowledgebase
    Hi 
     
    yes its very well is related to whether you have default roles, namespace etc and also please make sure you have select and usage permissions on the database/schema and tables.
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Tom Macfarlan – Community Spotlight

We are honored to recognize Tom Macfarlan as our Community Spotlight for October…

Leaderboard > Copilot Studio

#1
Romain The Low-Code Bearded Bear Profile Picture

Romain The Low-Code... 506 Super User 2025 Season 2

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 387 Super User 2025 Season 2

#3
DAnny3211 Profile Picture

DAnny3211 132

Last 30 days Overall leaderboard

Featured topics