Unable to connect with Mysql server

[19BQ1A0147]

In powerbi not getting maps and histogram charts.
And not able to connect with MySQL server with workbench.

I want help regarding this.

Thank you.

[19BQ1A0147]

Thank you for solution😊

[shafiz_p]

Hi @19BQ1A0147 

Hope that you are using MySql database connector instead of MSSql. Here are few steps you can take to resolve the issue:

1. Download and install the latest MySQL Connector/NET from this link. This connector is necessary for Power BI to communicate with MySQL databases.

2. Update power bi desktop to the latest version.

3. Make sure MySql is up and running.

4. Disable Encryption: Sometimes, disabling encryption for the connection can resolve the issue:

• Go to "File" > "Options and settings" > "Data source settings."
• Select your MySQL data source and click "Edit."
• Uncheck the "Encrypt connections" option and try connecting again

5. Make sure your internet connection is stable.

Hope this helps!!

If this solved your problem, please accept it as a solution!!

Best Regards,
Shahariar Hafiz

[19BQ1A0147]

I have installed MYSQL Connector and i have disable encryption also, then also not working.

[shafiz_p · Accepted solution]

The error message you're seeing is specific to Microsoft SQL Server, not MySQL. I think, you are using wrong connector for to establish connection.

If it is MySql, then try the below connector:

If Microsoft SQL server, then try the below connector:

Hope this will solve your problem !!