Forum Discussion
Unable to connect with Mysql server
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.
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 !!
4 Replies
- shafiz_p
Super User
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 HafizI have installed MYSQL Connector and i have disable encryption also, then also not working.
- shafiz_p
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 !!
Thank you for solution😊
