Does RLS in Semantic Model override Effective permission?

[sultanib]

Row Level Security is enabled and configured for a particular user and while testing for that person, the Effective permission for that person shows as "None". When tried to view the PBI report, it shows "This user does not have access to the dataset or report." 

It is ambiguous whether the user has access or not. Please clarify.

[NandanHegde · Accepted solution]

The user needs to be initiatlly given access at the dataset and report level for him/her to access the report at 1st aspect.

post that adding the user at role level (RLS), would filter the data as per need

[v-jianpeng-msft · Accepted solution]

Your solution is so great NandanHegde 

Hi, @sultanib 

If you define RLS in the semantic model, you will be prompted that you cannot access it. You need to grant your user a specific permission (read or write). For information on whether RLS is applied to different permissions, you can refer to the following documents:

Semantic model permissions - Power BI | Microsoft Learn

Row-level security (RLS) with Power BI - Microsoft Fabric | Microsoft Learn

Power BI implementation planning: Report consumer security planning - Power BI | Microsoft Learn

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[NandanHegde · Accepted solution]

The user needs to be initiatlly given access at the dataset and report level for him/her to access the report at 1st aspect.

post that adding the user at role level (RLS), would filter the data as per need