Single sign-on to DirectQuery sources via Kerberos

Many organizations have made significant investments in scalable on-premises data sources and have implemented user security rules/conditions in these sources. For these organizations, it's often preferable to use DirectQuery data connections that leverage both the resources of the source and the custom security rules. To address this scenario, the On-premises data gateway now supports a single sign-on feature that passes the identity of the Power BI user to the data source via Kerberos constrained delegation.

In the following image from the Manage gateways portal, the single sign-on setting for a SQL Server data source is exposed:

Single sign-on for DirectQuery

By default, the single sign-on ...

Get Mastering Microsoft Power BI now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.