Overview of single sign-on for on-premises data gateways in Power BI
You can get seamless single sign-on (SSO) connectivity, enabling Power BI reports and dashboards to update in real time by configuring your on-premises data gateway. You have the option of configuring your gateway with the following SSO options:
- Active Directory (AD) SSO, which includes:
- Kerberos constrained delegation.
- Security Assertion Markup Language (SAML).
- Azure Active Directory (Azure AD) SSO.
SSO is only supported by Power BI datasets and not by Power BI dataflows.
Supported data sources for SSO
AD SSO is usually configured for on-premises data sources that are secured within your on-premises network. Azure AD SSO is configured for data sources that support Azure Active Directory authentication, typically cloud data sources, secured behind an Azure Virtual Network.
While the on-premises data gateway supports SSO by using DirectQuery or Refresh for the AD-based SSO options, only DirectQuery is supported for Azure AD SSO.
Power BI supports the following data sources:
- Amazon Redshift (Azure AD)
- Azure Databricks
- Azure Data Explorer (Azure AD)
- Azure SQL (Azure AD)
- Azure Synapse Analytics (Azure AD)
- Denodo (Kerberos)
- Hive LLAP (Kerberos)
- Impala (Kerberos)
- Oracle (Kerberos)
- SAP BW Application Server (Kerberos)
- SAP BW Message Server (Kerberos)
- SAP HANA (Kerberos and SAML)
- Snowflake (Azure AD)
- Spark (Kerberos)
- SQL Server (Kerberos)
- Teradata (Kerberos)
- Tibco Data Virtualization (Kerberos)
SQL Server Analysis Services also supports SSO, but does so using Live connections, rather than using Kerberos or SAML. Power BI doesn't support SSO for M-extensions.
Interact with reports that rely on SSO
When a user interacts with a DirectQuery report in the Power BI service, each cross-filter, slice, sort, and report editing operation can result in queries that execute live against the underlying data source. When you configure SSO for the data source, queries execute under the identity of the user that interacts with Power BI. That is, they run through the web experience or Power BI mobile apps. Therefore, each user sees precisely the data for which they have permissions in the underlying data source.
You can also configure a report that is set up for refresh in the Power BI service to use SSO. When you configure SSO for this data source, queries execute under the identity of the dataset owner within Power BI. Therefore, the refresh happens based on the dataset owner's permissions on the underlying data source. Refresh using SSO is currently enabled only for data sources using Kerberos constrained delegation.
Now that you understand the basics of enabling SSO through the gateway, read more detailed information about Kerberos and SAML:
Submit and view feedback for