Couldn't connect to MySQL database data source issue to schedule refresh

[rem_time]

Hi everyone, 

We're trying to schedule a refresh of our dashboards but we couldn't get through the MySQL data source. The MySQL database that we've connected to is from one of our supplier while our company is using SQL Server. We have successfully tested the connection to the SQL Server source but we're just having error with the MySQL data source (as pictured below). 

We have installed the Connector Net v. 28 and also made sure that the credentials we are using are correct. Can you please point out what are we missing here?

 

Thank you in advance guys! 🙂

[v-luwang-msft]

Hi @rem_time ，

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien

[v-luwang-msft]

Hi @rem_time ,

Try to download and installed the latest version of client software,and remember to download  64 bit connector.

download link:

https://dev.mysql.com/downloads/mysql/ 

Similar error refer:

https://community.powerbi.com/t5/Power-Query/Power-BI-Desktop-Unable-to-Connect/td-p/8606 

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien