I can't connect MySQL on Google Cloud Platform by Power BI Desktop

[umekuro]

Hello.

I am unable to connect to MySQL on google cloud platform from PowerBI Desktop.

I have tried the following
1. Select MYSQL from New source in powerbi desktop
2.Enter the GCP instance name in the server field.
3.Enter the database name of MYSQL on GCP in Database.
4.Select the database in the credentials and enter the user name and password.

When I do so, I get this error.

Does anyone have a solution?

Thanks in advance.

[v-henryk-mstf · Accepted solution]

Hi @umekuro ,

As shown in the screenshot, to connect to the mysql data source, you need an additional connector.

Download here: MySQL :: Download Connector/NET

Then follow the steps below to try again:

For more details, you can read related blog:

Connecting MySQL to Power BI: A Comprehensive Guide (hevodata.com)

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

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

[amitchandak]

@umekuro , MySQL required IP whitelisting, please check if you are bale to connect it using mysql query browser or any other tool on the same machine

Also installed latest MySQL .net driver

https://dev.mysql.com/downloads/connector/net/