How can i connect Power BI to an hosted MySQL databse server

[Edouard1mushame]

I am trying to connect Ppower BI to my hosted MySQL database server, this is hosted on LWS (cpanel), i put the server address, the username, the password and the port number(3306), but i am getting the error attached.

Is there someone to help me how can i resolve it.

Thanks a lot for your support

[M_nwadibia · Accepted solution]

I think you need to install MySQL database server drivers on the server where you have Power BI hosted. 

I experienced this in the past with Oracle SQL. I installed Oracle Database driver on the Report server DB host server and it solved my problem