How To Connect Power BI to Hosted MySQL Database in Cpanel

[Anonymous]

Good day house,

Please, I am currently experiencing a challenge with Power BI and will appreciate any help/suggestion I can get.

I have a MySQL database which is hosted on cPanel hosting and I want to connect to it using Power BI desktop and already installed the recommended mysqlconnector, but i do not know how to connect it so I'll would really appreciate your help

[Anonymous]

Hi  @Anonymous ,

Whether your problem has been resolved? If yes, could you please mark the helpful post as Answered? It will help the others in the community find the solution easily if they face the same problem as yours. Thank you.

Best Regards

[Anonymous]

I actually have already installed the latest net driver and whitelisted my ip using Cpanel Remote MySQL, 

but i has errors like this

i want to know what should i put here in 

to be able to properly connect it

[Anonymous · Accepted solution]

Hi @Anonymous ,

Please refer the following official documentation to connect MYSQL in Power BI:

MySQL database

MySQL and Power BI, How Does It Work?

The following one is the thread which had the similar problem as yours, hope its solution can also help you solve the problem.

How To Connect Power BI to Hosted MySQL Database

---

When trying to connect with MySQL Workbench, I realized remote connections had to be enabled on the cPanel hosting. Once done, I was able to connect with Power BI.

---

Best Regards

[amitchandak]

@Anonymous , what is the error you are facing?

On the power bi machine install MySQL workbench and check you are able to access it. Ip whitelisting can be an issue 

Also, make latest .net driver is installed

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