Forum Discussion
Does RLS in Semantic Model override Effective permission?
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.
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
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.
2 Replies
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
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.