Row Level Security With Hierarchies in Power BI (Option 1)

During this session you will learn how to create reporting which enables everyone within your organisation to see only the information for which they are authorised.

The key benefits of this are:

1. Time saving - Maintenance of one set of data
2. Scale - The model is flexible as more individuals get added to the organisation
3. Secure - Leverages the current Microsoft infrastructure to maintain security by using the username of the logged in individual
4. Transparent - One set of data means that those who have the highest level of security can see exactly what everyone sees in the same report

We will be using a fictional hierarchy to create commission numbers for each individual, limiting them to see only their data and that of anyone who reports into them directly or indirectly.

All files for the session are in the link https://tinyurl.com/y3p5e7vr