Channel: Microsoft Power BI

Category: Science & Technology

Tags: microsoft power biadvanced rls designrls fundamentalspower bi dev campfiltering in rls rolesmicrosoft power platformrls roles power bipower bimicrosoftrls with app owns data embeddingcustom datarow level securityrlsdaxted pattison

Description: 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: github.com/PowerBiDevCamp/RowLevelSecurity PowerPoint Slides: github.com/PowerBiDevCamp/Camp-Sessions/raw/master/Session%2018%20-%20Developer%20Deep%20Dive%20into%20Row%20Levele%20Security.pptx Follow us on Twitter - twitter.com/mspowerbi More questions? Try asking the Power BI Community @ 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