Forum Discussion

KAATA's avatar
KAATA
Helper I
4 years ago
Solved

Integration between Power BI Service and Snowflake database via SSO

Hi, I am trying to set up the integration between Power BI Service and Snowflake database. The Snowflake database is on a private link. We should use the Direct query method and log in should be v...
Need Help
  • v-cazheng-msft's avatar
    v-cazheng-msft
    4 years ago

    Hi KAATA ,

     

    Per the official document, if you are working with reports that require SSO connectivity in DirectQuery mode to data sources deployed in an Azure virtual network(Azure VNet), Single Sign-On (SSO) through the data gateway to cloud data sources that rely on Azure Active Directory (AAD)-based authentication is important. It will help get seamless AAD SSO connectivity to Azure-based data sources, such as Snowflake on Azure through an on-premises data gateway. So, you need to enable it.

     

    After you enabling Azure AD Single Sign-On for Gateway, it should work for all the applicable data sources that relies on AAD-based authentication.

     

    If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please let me know. Thanks a lot!

     

    Best Regards,

    Community Support Team _ Caiyun

KAATA's avatar
KAATA
Helper I
4 years ago

Hi v-cazheng-msft,
Thanks for your input.
Yes, in short I had to enable both of the below integration settings:
- Snowflake SSO
- Azure AD Single Sign-On (SSO) for Gateway
Then I added a new data source to the gateway (pointing to exactly the same data source as in the desktop pbix file). I also enbaled SSO while adding the data source.
Thanks,
Katerina