Forum Discussion
Invalid connection credentials
You are using two totally different connection types. You need to decide if you want to stick with ODBC (although I can't see why) or you make sure that your native MySQL connection works demonstrably on all gateway cluster members.
Thanks for the reply lbendlin!
The ODBC test was just to show that the server was accessible from the gateway and the credentials we used were correct. We have only 1 server used as a gateway so that's the only "cluster member" we need to test.
How can we test the "native MySQL connection" directly on the gateway? Right now our only way to make a test is from the PowerBI website. It could be easier to isolate the problem and diagnose from the gateway (maybe we could gather more information)?
Note: after creating the new VM, we installed MySQL connector/NET (latest version). We had the "invalid credentials" error so we decided to install the exact same version that was on the old VM (6.9.10). Even with this old version we're still having the invalid credential message.
"We have only 1 server used as a gateway" I would recommend you rethink that approach
"How can we test the "native MySQL connection" directly on the gateway" Install the MySQL Workbench or Shell
Latest version is 8.26. Seems to work mostly fine, except when you have mixed sources with MySQL and Sharepoint.
Hello,
we tried the connection directly on the gateway with MySQL Workbench and the connection is working with the same user/password that we use on website https://app.powerbi.com.
We still get the error message "Invalid connection credentials" on website https://app.powerbi.com .
Do you have any ideas what we could try to resolve this issue ?
Thank you for your help !
