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

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