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