Forum Discussion
Data Source Security Without RLS
Hi, does anyone knows how to filter rows within a table based on their userprinciplename and organisation hierarchy without using RLS? There are so many roles need to be created in my situation and a...
v-zhenbw-msft
Community Support
Community SupportHi Anonymous ,
If you connect to a SQL Server using Direct Query, and if you don’t want to configure the RLS, you can configure the security roles in your data source.
When a user opens a report Power BI sends a query to the underlying data source, which applies security rules to the data based on the user's credentials.
Or you can configure Kerberos-constrained authentication against the source.
But Kerberos isn't available for all sources.
Please refer this document.
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-sso-kerberos
Best regards,
Community Support Team _ zhenbw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.