David Brenner on 11 May 2018 05:07:57
Currently there are admins for the gateway who can admin the environment and the data sources and users who can access specific data sources. There should be an intermediate level of admin capabilities that would allow PBI Gateway admins to assign users the rights to administer specific data sources. Our issue is that the passwords for the service accounts that are used in the DSN change regularly. As usage of the gate2way grows it will become unworkable for an individual or group to manage all the various DSNs in an organization. The DSN admin should have rights to modify any aspect of an existing DSN they have been assigned to administer, including the users who can utilize that DSN.