Power BI Snowflake user access connection issue

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.