Announcements
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.