Forum Discussion
How To Connect Power BI to Hosted MySQL Database in Cpanel
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 ...
Hi Anonymous ,
Please refer the following official documentation to connect MYSQL in Power BI:
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
Super User
Super UserAnonymous , 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/