Unanswered

Seeking Guidance on Connecting SQL Database with Microsoft Copilot Studio

(1) Share

Report

Posted on by Ali-Haider

Hello Community,

I am currently working on a project, and I am facing a challenge in connecting my SQL database with a Conversational Plugin in Microsoft Copilot Studio. I have explored various resources, but I would greatly appreciate your insights and expertise.

If anyone has experience or knowledge on establishing a connection between SQL databases and Microsoft Copilot Studio, could you please share your recommendations, tips, or step-by-step instructions? Any guidance or pointers would be immensely helpful.

Thank you in advance for your assistance. Looking forward to learning from the community's expertise!

Categories:

Calling actions from Copilot Studio

I have the same question (0)

All responses (7)

Answers (0)

alaabitar 1,503 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hello @Ali-Haider

For this I would recommend to create a power automate flow that can be called from Copilot Studio. In the Power Automate flow you will connect to your sql database and return the desired information.

Was this reply helpful? Yes No
adilei Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

What is the challenge? Can you elaborate?

Was this reply helpful? Yes No
RayBoone 77 on at

Like (0)

Report
Copy link

Link copied!

Has anyone done this--created a Power Automate flow to query SQL and return information to a CoPilot bot? I'd love to see how this might work.

Was this reply helpful? Yes No
ArindamGupta on at

Like (0)

Report
Copy link

Link copied!

I would like to know if you were able to do this successfully ? Please share insights

Was this reply helpful? Yes No
RayBoone 77 on at

Like (0)

Report
Copy link

Link copied!

I was able to get CoPilot to launch a Power Automate workflow to query data from a Power BI dataset. I believe the process would be very similar with SQL--instead of running a DAX query, you'd be running a TSQL query. One thing to note is that I believe the SQL connector may be a premium connector...can't remember. Here's what it looks like for Power BI. There is an "Execute a SQL Query" action in Power Automate.

Was this reply helpful? Yes No
CU14080713-0 3 on at

Like (1)

Report
Copy link

Link copied!

Hello Everyone,

Subject: Assistance Needed: Connecting Microsoft SQL Server Database in Microsoft Copilot Studio

I hope you're doing well. I am currently working on connecting a Microsoft SQL Server database within Microsoft Copilot Studio but have encountered some challenges. I would greatly appreciate it if anyone could share step-by-step guidance or any resources that could help me achieve this.

Thank you in advance for your support!

Best regards,
Anil Singh

Was this reply helpful? Yes No
ZA-04031847-0 8 on at

Like (0)

Report
Copy link

Link copied!

Hello Ali Haider,

Have you got any solution, i am also looking for same.

Best Regards,

Zeeshan Ali

Was this reply helpful? Yes No