I cannot connect to my MySQL server using Power Apps. I have installed the necessary components, including the MySQL Connector NET, but I am getting the error "Cannot find a database provider with the invariant name MySql.Data.MySqlClient". I am using MySQL Server 8.0, MySQL Workbench 8.0, and the On-Premises data gateway.
The Solutions:
Solution 1: Reinstall MySQL Installer with the 8.0.28 Version
The error is caused by a bug in MySQL Installer version 8.0.33. To resolve this, reinstall MySQL Installer using the older version 8.0.28. This will ensure compatibility with Power Apps and allow you to successfully connect to your MySQL server.
Solution 2: Downgrade MySQL Connector NET
If you encounter the "Cannot find a database provider with the invariant name MySql.Data.MySqlClient" error while connecting MySQL to Power Apps, try downgrading the MySQL Connector NET version to an earlier version. In this case, downgrading to version 8.0.28 resolved the issue.
Q&A
What’s the solution to fix the problem?
—
Downgrading to MySQL Connector 8.0.28.
Is the problem exists in the latest version of MySQL?
—
Yes, it is a bug in the 33-version of MySQL.
What is the solution recommended by MySql Staff?
—
The MySQL staff recommends installing MySQL Installer 8.0.28.
Video Explanation:
The following video, titled "Power BI Connecting to a database: Connect the MYSQL database ...", provides additional insights and in-depth exploration related to the topics discussed in this post.
SUBSCRIBE to Learn, Adopt, & Grow: https://bit.ly/3cAOw13 Power BI is a business analytics solution that lets you visualize your data and ...
