Getting error while connecting to MYSQL

[ShraddhaB1990]

Hello Team,

I am getting the error while connecting to power bi.

To give you idea of what all things have i tried.

1. The Port is Open.

2. The mysql connector is installed which is mysql-connector-net-8.0.20 this i have downloaded from Oracle community.

3. I have checked my Power BI desktop is of latest update June 2020 and of 64 bit.

it would be of really great help i have seen many posts but it did not help me.

Regards,

Shraddha

[amitchandak]

@ShraddhaB1990 ,

It is a cloud Db or local DB ?

Refer

https://social.technet.microsoft.com/wiki/contents/articles/32004.power-bi-tips-for-working-with-mys...

https://dev.mysql.com/doc/refman/8.0/en/problems-connecting.html

[ShraddhaB1990]

Thankyou for our prompt answer, its an on-premise database.