Using different snowflake logins in two datasets with the same source

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.