Forum Discussion

ITQual's avatar
ITQual
Regular Visitor
4 years ago

Invalid connection credentials

Hello,   I created new virtual machine for the on-premises data gateway. I used the same VM name as the older VM for the on-premises data gateway.   After the switch done, we now have issue to ha...
On-Premise Data Gateway
ITQual's avatar
ITQual
Regular Visitor
4 years ago

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.

lbendlin's avatar
lbendlin
Super User
4 years ago

"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.

  • ITQual's avatar
    ITQual
    Regular Visitor
    4 years ago

    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 !