There should be an option to not cache credentials for data sources from connections with Power BI. This is a security issue and does not go well with customers.
PowerBI Gateway needs a more sophisticated interface, affording more control to admins to flush the cache if necessary or quickly and easily upgrade all credentials when a user's password is reset (as per IT policies requiring monthly password resets). It doesn't make sense to need to update the password for every single data source used in every single report and dashboard as this is time consuming and means that for the end-users, the Business Intelligence system is effectively inoperable whilst the passwords are being reset. At present, resetting passwords via the online interface seems to not always work, so an offline interface on the Enterprise Gateway makes a lot more sense. If credentials are to be cached, a single credential should be cached for all datasets used by the analyst (e.g. a one-to-many relationship between credential and datasets. This way, the analyst would change their password once, in one place, as required, to maintain security of the system. And in 1 minute from resetting their network password, all of their dashboards and reports would be operational. If multiple credentials are stored by multiple analysts, the manager or admin could then have oversight and control of these. The Enterprise Gateway at present doesn't seem like an Enterprise grade product. Needs a lot of improvement.
