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.

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.