Separate credentials for each workspace - credentials issue

[ManuelaOsorio]

I have 2 workspaces (W1 , W2) on Power BI service. They are using the same reports that uses Snowflake connection, and I need to have in each workspace different credentials because are data of different companies. 

All reports use the same host and warehouse, and I configure two datasets with different users from different companies (tenants).

The isue is that when I change the credentials of one workspace (W1), the credentials of the another worspace (W2) are changed. It is an important security problem because each client needs differents credential.

I don't need to use any gateway

[GilbertQ]

Thanks for letting us know!

[GilbertQ · Accepted solution]

Hi @ManuelaOsorio 

This is to be expected because the credentials are shared across the Power BI Service

The only solution I can think of is to use the Power BI Gateway where you can then select which connection to use?

Or vote for the idea here: https://ideas.powerbi.com

[ManuelaOsorio]

Hi @GilbertQ I created the gateway and its working. Thanks!