Datasource credentials issue in Power bi service

Hi

We have several workspaces, with multiple reports in each, which are connecting to tables in a single AWS Redshift database endpoint. 

Each workspace has a different set of credentials for the Redshift DB (as they access different tables in the same DB).
But when I change the credentials in a dataset in workspace A (using credentials for user1 ) it is also changing a dataset in workspace B (using user2) - both have the same endpoint url but creds are different.

The reports are using different workspaces, datasets, credentials, only the jdbc connection url is the same.

How do I avoid this issue because at the moment I am having to use a single user with global access to the tables to prevent reports from failing?

Thanks