There are many videos on YouTube already dedicated to this topic. So why am I doing another one? Well, the goal here is not to teach you Row Level Security. My goal is to help you understand how Row Level Security works. In this video I will discuss what makes row level security work in Power BI:
- Ability to know who is connected to the model using USERPRINCIPALNAME() function
- Ability to define filters (static and dynamic) as well as group those filters in security roles
- Ability to assign users to one or more roles, which then defines what filters are applied when a user connects to the model.
Also, I am providing a dataset with this tutorial with roles create for an HR type of analysis. And, finally, I will show you how to test these security roles so we can emulate different users and see whether our logic works as it should.