Posts

Power BI - Home Menu Options

Image

How to Handle Employee Hierarchy in Power BI

Image
In this blog we will try to understand how to handle employee hierarchy and we will also learn about how to implement Row Level Security. Let us first understand what is employee hierarchy or organization hierarchy.  The level of hierarchy can be 3 or 4 or 5 etc. depending on the employee strength and company policy. Looking at the image above we can understand that :  it depicts a 3 level hierarchy  A is the top most employee in the hierarchy, may be we say he/she is CEO  B and C reports to A and D,E and F reports to B. So organization hierarchy basically determines  who is reporting to whom what is the level of hierarchy who is the top most person how many employees reports to a manager Now we have a basic understanding of organizational hierarchy so lets move to the 2nd important aspect that we are going to learn i.e. Row Level Security (RLS).  RLS is implemented so that each employee get to see only and only the relevant information. For example : Consider the above image depicts t