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!
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
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.
I would like to know if you were able to do this successfully ? Please share insights
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.
What is the challenge? Can you elaborate?
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.