Forum Discussion

Nazdac911's avatar
Nazdac911
Icon for Helper II rankHelper II
3 years ago

Advanced Power BI security Scenario

Hi all  I am facing a big challenge to build a security system inside my compnay ,  its simillar to the follwing problem :  imagine a school system :  I have three dim tables (Managers , Teachers...
Need Help
Tutorial Requests
Nazdac911's avatar
Nazdac911
Icon for Helper II rankHelper II
3 years ago

Since its groupe level security so I will use static RLS !

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago

Cool. Next step is to define the roles. I think you have that already. Next step is to define the scope for each role, ie the DAX formula that evaluates to true for each of them.  These formulas then need to be applied to the DIMENSION tables in your data model. No point in applying the RLS to fact tables - the RLS rules must be able to impact filters.