Unable to Connect Power BI to MySQL Database

[manish_divekar]

I am experiencing an issue while trying to connect my MySQL database to Power BI. Despite following the necessary steps, I keep encountering an error during the connection process.

Setup Details:

• Power BI Version: 2.140.1577.0 (64-bit, February 2025)

• MySQL Version: 8.0

• Connector Used: MySQL .NET Connector (versions tried: 9.1.0, 8.0.33, 8.0.32)

Troubleshooting Steps Taken:

• Installed multiple versions of the MySQL .NET Connector and ODBC Connector.

• Restarted my laptop after each installation.

• Verified installation but still unable to establish a connection.

Despite these efforts, the issue persists. I would appreciate any guidance on how to resolve this.

[manish_divekar]

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!

[pankajnamekar25 · Accepted solution]

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.

[manish_divekar]

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!