Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
We currently have a mariadb hosted in azure which until Friday afternoon last week was pulling data in to powerbi with no issues. Now, in M365, when trying to get the data to refresh, we are getting variants of this error.
We were unable to find a database provider with invariant name 'MySql.Data.MySqlClient'.
Hi @KyleMCI ,
One possible solution is to ensure that the MySQL connector is installed and up-to-date. You can download the latest version of the connector from the MySQL website. Additionally, you may want to check the connection string to ensure that it is correct and up-to-date.
Another possible solution is to check the firewall settings for the MySQL server. It is possible that the firewall is blocking connections from Power BI. You may need to add an exception to the firewall to allow connections from Power BI.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.