This camp sessions explores how to implement custom security policies in Power BI reports by designing Power BI datasets using Row Level Security (RLS). The session will begin with a quick review of creating RLS roles in Power BI Desktop and writing DAX expressions for RLS rules. The session will demonstrate common design patterns in the Power BI community for static RLS and dynamic RLS. Along the way, campers will learn how to integrate RLS security features when developing with App-Owns-Data embedding by writing RLS rule expressions which inspect the UserName and CustomData properties passed by the developer in an embed token.

What Campers Will Learn:

  • Row Level Security Fundementals
  • Designing with Dynamic RLS
  • Understanding How Relationships Affects RLS

Session Prerequisites

Campers should be familiar with the fundamentals of working with Row Level Security in Power BI Desktop. Experience developing with Power BI embedding is recommended but not required.