Datagateway issue: UserX can login, UserY cannot login

[KJanssens]

I have a very strange situation.

We are trying to connect to a MySQL database through a data gateway (set up by myself, let's say UserZ).

UserX can use the following connection just fine in DataFlow1:

MySQL.Database('localhost', 'databaseA')

... and sees all databases in the MySQL server (databaseA, databaseB, databaseC)

When UserY tries to edit the same connection in DataFlow1, he gets "Unexpected Error" when trying to login with the same MySQL credentials, in this case the user 'root' (I know root should not be used, but this is only a test setup). UserY has to change the connection to

MySQL.Database('localhost', 'databaseB')

... and then also sees all databases in the MySQL server (databaseA, databaseB, databaseC)

When UserX tries to edit DataFlow1 again, he has to revert the changes that UserY has done in order to be able to connect...

What on earth is causing this strange behaviour?

[KJanssens · Accepted solution]

while typing the above question, I fiddled around in PowerBI Service, and found a place where you can set permissions for each datasource level on a datagateway. There, UserY was not added...