Forum Discussion
Unable to Connect Power BI to MySQL Database
Hello manish_divekar
Ensure Correct Connector Version Use MySQL Connector .NET 8.0.22 (Power BI is known to work best with this version).
Check TLS Compatibility MySQL 8.0 enforces TLS 1.2 by default. Add TlsVersion=TLSv1.2; in the Advanced Options of the connection string.
Use ODBC Instead If the .NET connector fails, try using MySQL ODBC 8.0 Driver and connect via ODBC Data Source in Power BI.
Enable MySQL Remote Access If connecting to a remote server, ensure MySQL allows external connections (bind-address=0.0.0.0 in my.cnf and GRANT ALL PRIVILEGES for your user).
Run Power BI as Admin Right-click Power BI Desktop and select Run as administrator before connecting.
Thanks,
PankajIf this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.
Hello manish_divekar
Ensure Correct Connector Version Use MySQL Connector .NET 8.0.22 (Power BI is known to work best with this version).
Check TLS Compatibility MySQL 8.0 enforces TLS 1.2 by default. Add TlsVersion=TLSv1.2; in the Advanced Options of the connection string.
Use ODBC Instead If the .NET connector fails, try using MySQL ODBC 8.0 Driver and connect via ODBC Data Source in Power BI.
Enable MySQL Remote Access If connecting to a remote server, ensure MySQL allows external connections (bind-address=0.0.0.0 in my.cnf and GRANT ALL PRIVILEGES for your user).
Run Power BI as Admin Right-click Power BI Desktop and select Run as administrator before connecting.
Thanks,
Pankaj
If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.
Hi Pankaj,
Thank you for your detailed response and helpful troubleshooting steps. I followed your suggestion and used the MySQL ODBC 9.2 Driver, and it worked perfectly! Your guidance on TLS compatibility and remote access settings was particularly useful.
I really appreciate your support—thanks again for sharing this solution!