Using different snowflake logins in two datasets with the same source

[rafaelags]

Good morning,

We are having conflicts in the Power BI service when using different users on different reports but within the same workspace. Currently, within our workspace we have two different datasets but both use the same Snowflake connector and the same server. When publishing the report we set up different users to use the connector. To make sure, we also do the login for each user within the configuration of each dataset in the Service itself. What we see is that both datasets are using the same login user which is the last one configured in any of them.

How could we do so that this does not happen and that each dataset uses its own user?

[jaweher899]

There are a few steps you can take to ensure that each dataset uses its own user when connecting to Snowflake:

1. Use different gateways: Configure a separate gateway for each dataset, and set the appropriate user for each gateway. This way, the Power BI service will use the correct user for each dataset.

2. Use different credentials: Instead of using the same user for both datasets, use different credentials for each dataset. This can be done by creating separate connection strings or by using different usernames and passwords.

3. Use DirectQuery: Instead of using the same user for both datasets, use DirectQuery to connect to Snowflake. This way, each report will use the user that is currently logged in to the Power BI service.

4. Use separate workspaces: Create separate workspaces for each dataset and publish the reports to the appropriate workspace. This way, the reports will use the user that is currently logged in to the Power BI service.

5. Use row-level security: Implement row-level security to limit the data access for each user. This way, each user will only see the data that they are authorized to see.

It's important to note that the best practice will depend on the specific use case, data structure, and the requirement of the organization. It's also recommended to consult with a Power BI administrator or Snowflake administrator to ensure that the solution meets the organization's security and compliance requirements.

[rafaelags]

Thank you for your answer.

Regarding point 2, different logins are used, but take into account the last one to be configured.

On point 4, separating it into different workspaces reports the same behaviour.

It seems that what defines the connection is the server and the wharehouse, not taking into account the login.

We are considering the use of Gateways as an alternative, but it would not be desirable.