Forum Discussion

SimplesHoT89's avatar
SimplesHoT89
Frequent Visitor
4 years ago
Solved

Data Gateway Invalid connection credentials

Hi all,

 

I am trying to add a data source to my gateway. This datasource is a MySQL DB running in AWS. The refresh in PBI Desktop as well as with the personal gateway on my computer works without any issues. Now i sucessfully installed the gateway on a terminal server. However when i try to add the data source in the PBI service i receive the "invalid connection credentials" message, while using the exact same DB credentials i use for PBI Desktop as well as the MySQL workbench. I also checked the ports and tried to ping the DB from the terminal server, which was successfull as well.. what could i be missing here?

 

The data source cannot be created.
Invalid credentials for the connection.

Details:

S10 Power BI Data Gateway: the credentials provided for the "MySql" source are invalid. (Source at "XXX".)

 

thanks for your help

Need Help
  • SimplesHoT89's avatar
    SimplesHoT89
    4 years ago

    I solved the issue myself. Somehow my DB User was allowed to connect to the data source directly via PBI Desktop and the MySQL Workbench but is not allowed to do this via the data gateway. So i assume there is any kind of remote role that wasnt activated which didnt allow the gateway to access this.

4 Replies

  • SimplesHoT89's avatar
    SimplesHoT89
    Frequent Visitor
    4 years ago

    I solved the issue myself. Somehow my DB User was allowed to connect to the data source directly via PBI Desktop and the MySQL Workbench but is not allowed to do this via the data gateway. So i assume there is any kind of remote role that wasnt activated which didnt allow the gateway to access this.

    • techspert316's avatar
      techspert316
      Frequent Visitor
      2 years ago

      This worked for me when I used the admin credentials! Can you please specify the role that we need to assign to the user? It cannot be admin in my case since the dba will not allow it.

  • collinq's avatar
    collinq
    Super User
    4 years ago

    Hi SimplesHoT89 ,

     

    I am initially wondering about two possibilities.  First, do you have permissions to create a new connection in your Gateway settings?  Second, is the connection from the server different - as in, do you need to use a FQDN that you do not have to use on your personal machine?  (Or, you may have to enter the IP and not the name.)

    • SimplesHoT89's avatar
      SimplesHoT89
      Frequent Visitor
      4 years ago

      Hi collinq,

       

      thanks for the quick reply. As i installed the gateway myself and configured it in the service as well i have admin rights for this gateway. i also have the mysql workbench on that machine which lets me connect to the db without a problem