Power BI Snowflake user access connection issue

[Anonymous]

We are having issues refreshing Snowflake data in Power BI using different Snowflake logins for each area of the business (e.g. IT login, HR Login).

We have a workspace for HR and one for IT that contains a dataset and reports that only relate to the relevant area.  The Snowflake user for HR can only view HR data and IT can only view IT data.

When we enter the Data Source credentials for the IT workspace to the refresh this data the HR data stop working, and vice versa.   Even though the datasets are named differently and in different workspaces they seem to be using the same login credentials.  Is there anyway that we can user different Snowflake logins in Power BI online?

[Anonymous · Accepted solution]

Hi @Anonymous,

After a report that is based on the Snowflake connector is published to the Power BI service, the dataset creator has to update settings for the appropriate workspace so that it will use SSO.

Because of the way that Power BI works, SSO will only work when no data sources are run through the on-premises data gateway. Limitations are listed below:

• If you're using only a Snowflake source in your data model, then you can use SSO if you choose not to use the on-premises data gateway.
• If you're using a Snowflake source and another source, then you can use SSO if none of the sources use the on-premises data gateway.
• If you're using a Snowflake source through the on-premises data gateway, AAD credentials aren't currently supported. This consideration might be relevant in case you're trying to access a VNet from a single IP with the gateway installed on it, rather than from the entire Power BI IP range.
• If you're using a Snowflake source and another source that requires a gateway, you need to use Snowflake through the on-premises data gateway as well. You won't be able to use SSO in this case.

If you aren't using the gateway, you're all set. When you have Snowflake credentials configured on your on-premises data gateway, but are only using that data source in your model, you can click the toggle on the Dataset settings page to turn off the gateway for that data model.

For more information, you can refer to：

Connect to Snowflake in Power BI Service 

Snowflake troubleshooting guide 

Hope it helps,

Community Support Team _ Caitlyn

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.