So, you want to share a report with your users. You want to share all the data with the manager. However, only allow each team member to see their own data. As the team changes, this all needs to be done automatically with a minimal amount of work. That situation is just one of many types of situations where Row Level Security (RLS) in Power BI comes into play. RLS is a powerful feature that allows you to control access to data based on roles, ensuring data security and privacy. These situations could include sales data for different regions, customer data for other sales representatives, or financial data for various departments. This session is intended to take you from zero to hero in understanding and implementing RLS.

During the session, you'll not only learn how to set up RLS and configure different RLS filters using both static and dynamic RLS roles, but you'll also get hands-on experience. We'll guide you through troubleshooting RLS issues and share best practices for setting up RLS. Plus, we'll reveal the solution we used to set up multi-level hierarchical RLS for a call centre, which can be applied in various scenarios. Get ready to discover how the client can administer the RLS themselves.

When you arrive at the session, you might have zero or just a bit of knowledge about Power BI Row-Level security. But when you leave, you'll have followed some simple steps, learned insider hints and tips, and be ready to confidently build your own RLS solution when you return to the office. We'll also provide links to other resources for further learning. Get ready to transform from Zero to Hero with your newfound RLS expertise.

Any person reviewing this session, and if it is selected, will be able to claim a small Scottish Delicacy by emailing rwlp.french@gmail.com ;-)