Forum Discussion
Kudo CommanderFor Snowflake cloud connections using OAuth authentication, is an on-premises data gateway required
For Snowflake cloud connections using OAuth authentication, is an on-premises data gateway required for scheduled refresh?
Hi manoj_0911 ,
Thanks for reaching out to Microsoft Fabric Community.Snowflake allows Power BI users to connect using Identity Provider credentials with an OAuth 2.0 implementation to provide an SSO experience when accessing Snowflake data. In this setup, the Power BI service uses an embedded Snowflake driver to connect directly to Snowflake, which eliminates the need for an on premises Power BI gateway.
Because of this, a gateway is generally not required for scheduled refresh when using OAuth authentication with Snowflake.
A gateway would only be required if the Snowflake instance is accessible only through a private network configuration such as PrivateLink, or if your organization requires all outbound connections to go through a gateway.
For more details, please refer to the documentation:
Power BI SSO to Snowflake | Snowflake Documentation
Connect to Snowflake with Power BI - Power BI | Microsoft Learn
Hope this helps. Please reach out for further assistance.
Thank you.
4 Replies
- d_m_LNK
Super User
Generally On-Prem gateways are usually required because of oranizational access from the Power BI service to your datasource. We don't have snowflake in our environment so can speak to those specifically but for SQL servers this is the case.
v-veshwara-msftCommunity Support
Hi manoj_0911 ,
Thanks for reaching out to Microsoft Fabric Community.Snowflake allows Power BI users to connect using Identity Provider credentials with an OAuth 2.0 implementation to provide an SSO experience when accessing Snowflake data. In this setup, the Power BI service uses an embedded Snowflake driver to connect directly to Snowflake, which eliminates the need for an on premises Power BI gateway.
Because of this, a gateway is generally not required for scheduled refresh when using OAuth authentication with Snowflake.
A gateway would only be required if the Snowflake instance is accessible only through a private network configuration such as PrivateLink, or if your organization requires all outbound connections to go through a gateway.
For more details, please refer to the documentation:
Power BI SSO to Snowflake | Snowflake Documentation
Connect to Snowflake with Power BI - Power BI | Microsoft Learn
Hope this helps. Please reach out for further assistance.
Thank you.- v-veshwara-msft
Hi manoj_0911 ,
Just checking in to see if you query is resolved and if any responses were helpful.
Otherwise, feel free to reach out for further assistance.Thank you.
- v-veshwara-msft
Hi manoj_0911 ,
We wanted to kindly follow up regarding your query. If you need any further assistance, please reach out.
Thank you.
