Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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...
Data Protection
Need Help
v-zhenbw-msft's avatar
v-zhenbw-msft
Community Support
5 years ago

Hi 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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    How can I set a security rules to the data source based on user's credentials? Is it using Native Based Query?

     

    Another question, how can I set the power bi report so that when user open the report, the report will automatically updated based on the security applied to the user credentials?