Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

A new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.

kayu1
‎06-29-2020 09:20 AM

Announcing General Availability (GA) of enhanced connectivity for Snowflake

We are excited to announce the that the enhanced capabilities added recently to the Power BI Snowflake connector are now GA, including the ability to connect to Snowflake without an on-premises data gateway as well as support for Azure Active Directory (AAD) authentication and SSO in DirectQuery mode in the Power BI service.

The enhanced connector capabilities streamline how Power BI accesses Snowflake data warehouses in three ways:

  • Removing the requirement for an on-premises gateway and thus eliminating the friction associated with deploying and managing gateways.
  • Providing a new authentication method for Snowflake through AAD. Snowflake user identities can be synced with AAD to enable data access.
  • Enabling SSO with Power BI based on AAD authentication. With SSO enabled in the data source definition, users opening or refreshing a report in DirectQuery mode are authenticated and authorized seamlessly with their Power BI (AAD) identities to access Snowflake.
The following screenshot shows how to enable SSP for a Snowflake data source.

Announcing_General_Availability_GA_of_enhanced_connectivity_for_SnowflakeAnnouncing_General_Availability_GA_of_enhanced_connectivity_for_Snowflake

If you find the SSO option (checkbox at the bottom of the screen) unavailable, then contact your Power BI service admin to enable the corresponding tenant setting under Tenant settings in the Power BI Admin portal, as depicted in the next screenshot.

Announcing_General_Availability_GA_of_enhanced_connectivity_for_SnowflakeAnnouncing_General_Availability_GA_of_enhanced_connectivity_for_Snowflake

The enhanced Snowflake connector is the result of an on-going collaboration between the Power BI and the Snowflake product teams. For further details, see the enhanced Snowflake connector documentation for Power BI Desktop, for Power BI Service, and this article on the Snowflake website.

Additional resources

To learn more, check out the following webinar on how to build scalable BI solutions on your Snowflake Cloud Data Platform using Power BI: Build Scalable BI Solutions Using Power BI and Snowflake.

0