Forum Discussion

SathiMathi's avatar
SathiMathi
Frequent Visitor
8 years ago
Solved

How to implement RLS for company hierarchy

Hi Leaders,

 

I am new to Power BI, I am struggling to implement RLS for last few weeks. I am not sure how to proceed with my scenario, please someone help me to give me idea to implement my scenario. its great help.

 

here is my requirement.

 

My tables are:

 

 

 

Report 1 and 2 will change based on the user login and permission level  ('User Access' and 'User Permission'.). if am team head then i can see all team progress in summary view and if i am login with branch head then i can see all department and team progress.

 

Two level of reports 

Report 1: summary of all one's from completed, in progress and issues. User click on the number then the 

Report 2 will display with those related values based on the 'User Access' and 'User Permission'.

 

Thanks a lot for your idea and help.