Forum Discussion
Snowflake SSO and import mode
Yes, you can utilize Single Sign-On (SSO) with Snowflake in Import Mode within Power BI. Here's how it works:
Power BI Desktop:
When connecting to Snowflake, select the Microsoft Account option for authentication.
This leverages your Microsoft Entra ID (formerly Azure AD) credentials to establish the connection.
Power BI Service (Scheduled Refresh):
After publishing your report, navigate to the dataset settings.
Under Data source credentials, choose OAuth2 as the authentication method.
Sign in with your Microsoft Entra ID credentials.
This setup allows the Power BI Service to use your Entra ID token to authenticate with Snowflake during scheduled refreshes.
Important Considerations:
SSO Configuration: Ensure that SSO is properly configured between Microsoft Entra ID and Snowflake. This involves setting up an external OAuth security integration in Snowflake and enabling SSO in the Power BI Admin portal.
Role Mapping: The user principal name (UPN) from Entra ID should map correctly to a user in Snowflake. This ensures that the appropriate permissions are applied during data access.
Token Expiry: Be aware of token lifetimes. Microsoft Entra ID tokens have expiration periods, and you may need to re-authenticate periodically, especially if there are changes to your credentials or organizational policies.
More informatation by the links:
https://docs.snowflake.com/en/user-guide/oauth-powerbi
https://learn.microsoft.com/en-us/power-bi/connect-data/service-connect-snowflake
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Super UserYes, you can utilize Single Sign-On (SSO) with Snowflake in Import Mode within Power BI. Here's how it works:
Power BI Desktop:
When connecting to Snowflake, select the Microsoft Account option for authentication.
This leverages your Microsoft Entra ID (formerly Azure AD) credentials to establish the connection.
Power BI Service (Scheduled Refresh):
After publishing your report, navigate to the dataset settings.
Under Data source credentials, choose OAuth2 as the authentication method.
Sign in with your Microsoft Entra ID credentials.
This setup allows the Power BI Service to use your Entra ID token to authenticate with Snowflake during scheduled refreshes.
Important Considerations:
SSO Configuration: Ensure that SSO is properly configured between Microsoft Entra ID and Snowflake. This involves setting up an external OAuth security integration in Snowflake and enabling SSO in the Power BI Admin portal.
Role Mapping: The user principal name (UPN) from Entra ID should map correctly to a user in Snowflake. This ensures that the appropriate permissions are applied during data access.
Token Expiry: Be aware of token lifetimes. Microsoft Entra ID tokens have expiration periods, and you may need to re-authenticate periodically, especially if there are changes to your credentials or organizational policies.
More informatation by the links:
https://docs.snowflake.com/en/user-guide/oauth-powerbi
https://learn.microsoft.com/en-us/power-bi/connect-data/service-connect-snowflake
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly