if you use AAD, you can enable SSO in the next step. The dataset can be signed into Snowflake with Basic or OAuth2 (AAD) credentials. Select Data source credentials and sign in. Select the appropriate workspace, then choose Settings from the more options menu that's located next to the dataset name. Sign in to Power BI using dataset creator credentials. To turn on SSO for a dataset, follow these steps: When you have Snowflake credentials configured on your on-premises data gateway, but are only using that data source in your model, you can click the toggle on the Dataset settings page to turn off the gateway for that data model. If you aren't using the gateway, you're all set.
#How to use snowflake pro how to#
Learn more about how to use the on-premises data gateway, in What is an on-premises data gateway?
#How to use snowflake pro update#
Configuring a Dataset with AADĪfter a report that is based on the Snowflake connector is published to the Power BI service, the dataset creator has to update settings for the appropriate workspace so that it will use SSO.įor more information about using AAD and SSO, refer to the following announcement that describes the steps and support for using AAD and SSO with Snowflake: Data gateway support for SSO with AAD. After you enable the setting, it may take up to an hour for it to take effect.Īfter SSO is enabled you can use reports with SSO. This step is required to consent to sending your AAD token to the Snowflake servers.
Select Tenant settings, then scroll to locate Integration settings.Įxpand Snowflake SSO, toggle the setting to Enabled, then select Apply. Select Settings from the page header menu, then select Admin portal. Sign in to Power BI using global admin credentials. This setting approves sending AAD credentials to Snowflake for authentication for the entire organization. To enable SSO, a global admin has to turn on the setting in the Power BI Admin portal. Power BI Service configuration Admin portal If you're a Power BI dataset creator, reference Power BI Service configuration - Configuring a dataset with AAD to learn how to enable SSO.If you're a Power BI admin, reference Power BI Service configuration - Admin Portal to learn how to enable SSO.If you're the Snowflake admin, read the Power BI SSO to Snowflake - Getting Started article in the Snowflake documentation.To configure AAD integration and optionally enable SSO, follow the steps in this article: Basic authentication works similarly to other connectors in the service. You can also choose to enable AAD authentication without using SSO. Parts of the integration require different administrative roles across Snowflake, Power BI, and Azure. Snowflake has an additional capability for Azure Active Directory (AAD), with an option for SSO. Connecting to Snowflake in the Power BI service differs from other connectors in only one way.
0 kommentar(er)
