Not able to connect Power BI with MySql server

[jainanish]

Hi all, i have power bi version 2.126.1261.0 and mysql server 8.0. I am trying to connect powerbi with mysql and getting an error. I initially thought that problem was related to mysql server so i tried to connect my sql server from dbveaver as well. I was able to do that but not with power bi. Can you help me please. been scratching my head over this for past week.

[Anonymous]

Hi, @jainanish 

Make sure that this component is installed not only on the local machine running Power BI Desktop, but also on any computer that hosts the on-premises data gateway.

Check the SSL configuration, if the MySQL server has SSL enabled, you need to ensure that the SSL certificate is installed and configured correctly on the computer running Power BI Desktop. This step is essential to establish a secure connection. You can refer to the following link:

Solved: MySQL Connector Not Working - Microsoft Fabric Community

How to Get Your Question Answered Quickly 

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

@jainanish See if this helps: tcp - Unable to Connect to MySQL local server 3306 in Power BI - Stack Overflow