Unable to connect to database through Personal Gateway

[Percy]

Hello,

I am having a connection issue with personal Gateway to our client database. One of our client stored their data in their database, and we managed their reporting through Power BI. Our client has created a credential and also added our IP address to whitelist to make sure we can access their data through Power BI. It worked on PBIX file and we can also refresh the data on desktop.

But we want to automate the refreshing on Power BI service. So we have created a personal gateway (On Promise), but it pop up an error message when we try to connect. We have used the same credential as we used in Desktop PBIX file. It's not working through Gateway.

Does anyone has the same experience? Is there any suggestion? Thank you in advance.

Percy

[Percy]

Thank you Freginier!

Maybe i have not explained myself well. As our client's data has been stored in MySQL database with protection. Only IP address in their whitelist can be access the data. We don't have a static IP address in our local machine and we are using a VPN and added the IP address to our client database.

We can connect through VPN and refresh data in local PBIX file. When we set up the auto refreshing in Power BI service, it doesn't work if we connect directly. That's the reason we want to set up a personal gateway to access our client database.

please let me know if it's clear.  Hope you can share some idea with me. Thanks.

Percy

[freginier]

Your personal gateway is in the same computer ? 

What do you have in MySQL Log?