Snowflake SSO Integration to Power BI at Organization level

[manishmadagowni]

Hi,

we are in process of enabling SSO for PowerBI to Snowflake connections. we are looking for documentation which contains instruction to implement this. Also, are we restricted to directquery when we implement SSO to Power BI and snowflake.

Thank you 

Manish

[amitchandak]

@manishmadagowni , refer

https://learn.microsoft.com/en-us/power-bi/connect-data/service-connect-snowflake

https://docs.snowflake.com/en/user-guide/oauth-powerbi

[manishmadagowni]

Thank you for your response. can we use import with Snowflake SSO?

[DarinSpence]

I just setup SSO on Snowflake for Microsoft Accounts.  I had to do all of this:  https://docs.snowflake.com/en/user-guide/oauth-powerbi

Gotcha's
1. Make sure that the UserPrincipalName (me@mycompany.com) = Snowflake User Record's 'login' field.  
2. Make sure your Snowflake DatabaseName is either DATABASENAME or databasename (no CamelCase)