danielzana's avatar
danielzana
Icon for Microsoft Employee rankMicrosoft Employee
4 years ago

Power BI Dev Camp Session 18 - Developer Deep Dive into Row Level Security (RLS)

This Dev Camp session 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

 

Demo Files 

 

PowerPoint Slides 

 

Follow us on Twitter - https://twitter.com/mspowerbi

 

More questions? Try asking the Power BI Community @ https://community.powerbi.com/

 

0:00 Intro
2:13 Row Level Security Fundamentals
21:02 Dynamic RLS Designs
32:37 Advanced RLS Designs
41:30 Using RLS in App Owns Data Embedding
44:17 Filtering in RLS Roles with UserName and CustomData

 

#powerbi #rowlevelsecurity #RLS

 

No RepliesBe the first to reply