Mysql - Power BI unable connection

[Anonymous]

Hello to all, I'm trying to connect my MySQL databases to Power BI but I'm getting an error. I checked the previous message on the forum, read the comments and apply suggestion however it didn't work. You can see the error in the figure. Also, you can see admin user details on Mysql. Do I need to give all access or default one is enough for connection to Power BI? I would be happy If you suggest some solutions.

[v-chenwuz-msft]

Hi @Anonymous ,

Does this service local on remote machine? If yes, please check if the host of the user( admin) is allowed from other ip or some ips you specified. If no, please add a port behind the localhost, such as 3306.

To get data from mysql, only need select permission.

Best Regards

Community Support Team _ chenwu zhu

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

[Anonymous · Accepted solution]

Hello, thanks for answering. I tried with port but it didn't work well. I used ODBC. I created ODBC MySQL Driver and connect it to Power BI. However for my case, firstly I tried MySQL ODBC 8.0 ANSI Driver but I got an error with it after that I tried MySQL ODBC 8.0 Unicode driver and it's working properly. 

https://www.youtube.com/watch?v=K3GZidOwGmM&ab_channel=InternetServicesandSocialNetworksTutorialsfro...

[v-chenwuz-msft]

Hi @Anonymous ,

I'm glad your question was solved, please mark it as the correct answer so that more people can find it.

Best Regards

Community Support Team _ chenwu zhu