Datasource credentials issue in Power bi service

[Stainset]

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

[blopez11]

I've encountered the same for other cloud hosted databases as well, curious to see the responses you get

[Stainset]

Hi @blopez11 

How do you get around it at the moment, global access also?

[blopez11]

Unfortunately, yes