Power Platform Community Forum Thread Details

Microsoft Copilot Studio connection to MySQL database

I’ve been working on connecting Microsoft Copilot directly to my local MySQL database. Here’s what I’ve done so far:

Created a MySQL user with the necessary privileges to allow remote access.
Set up an on-premises data gateway to facilitate the connection between the MySQL database and Microsoft Power Automate.
Added the MySQL connector in Power Automate to enable communication between the database and Copilot Studio.

However, I’m encountering the following challenges:

At times, I encounter a connection error indicating that the MySQL connector is receiving an incorrect request.

The connector ‘MySQL’ returned an HTTP error with code 400. Error Code: ConnectorRequestFailure
No response from Copilot: In certain cases, the bot doesn't return any response after I attempt to interact with the database.
General message about database access: I also receive messages stating that Copilot doesn’t have direct access to databases and cannot execute queries or show real-time results.

After doing some additional research, I found that Microsoft Copilot Studio doesn't seem to support direct execution of MySQL queries on a local database.

Could you please provide some guidance on whether there's another approach or if I'm missing something in my setup?

I tried to connect MySQL database to Microsoft Copilot Studio. However, it seemed impossible to directly retrieve data from the database.

Categories:

General

Quick Links

Leaderboard