Dynamic Row-level Security 🔐 - Based on Dimension Tables

Dynamic RLS provides a more flexible option in Power BI when it comes to Security Settings.
It utilizes the USERPRINCIPALNAME function to pick up who's logged in, and a bit (or a lot of) DAX logic.

I really love this setup as it helps to drive real-world security options without adding too much complexity and performance overhead to my models.

If you also want to learn how to create RLS based on any dimension tables and any number of queries, make sure to watch till the end!


Have a good one,
Roland

💪 New videos coming every Tuesday 🤹‍♂‍
🤘 New short videos coming every Friday 👨‍🏫

📝 BLOG POST: https://bilingualanalytics.com.au/dyn...

🎬 MORE VIDEOS:
Power BI Row-level Security - Complete Guide -    • Power BI Row-level Security - Complet...  

Power BI & Power Automate - How to automate reporting process -    • Power BI & Power Automate - How to au...  

How to prepare for the DA-100 Exam - My journey, learning materials & what to expect - Power BI Tips -    • How to prepare for the DA-100 / PL-30...  

🔗 LINKS:
MS RLS Guidance - https://docs.microsoft.com/en-us/powe...

Chapters:
00:00 Intro
00:36 Dynamic RLS
01:01 Topics Covered
01:47 Problem To Solve - Issues
02:41 Users Table
03:16 Basics
03:58 Role #1 - TRUE/FALSE
04:31 Role #2 - VARIABLE
05:08 Role #3 - Manage No Restriction
06:02 Role #4 - Combine #2 and #3
06:54 Role #5 - Optimize DAX
07:44 Quick Summary
08:21 Role #6 - Pick-Up User's Restriction
10:00 Role #7 - Optimize DAX 2
10:36 What's Next?
11:19 Role #8 - Expand The Logic
12:00 DEMO
12:30 How To Manage Dynamic RLS
13:02 DAX - Performance To Keep In Mind
13:37 Flexible Logic
13:55 HIDE Users Table !!!
14:12 Food For Thought
15:02 Summary
15:19 Question Of The Day
15:36 End

▼▼▼▼▼▼▼▼▼

Make sure to hit the 👍 button and ❗❗ SUBSCRIBE ❗❗ to my channel.
If you have any questions, just let me know either in the comments down below 👇 or send us an e-mail 📩.

▲▲▲▲▲▲▲▲▲

🤝 HOW TO CONNECT 🤝
LinkedIn -   / bilingualanalytics  
Twitter -   / bilanalytics  
Subscribe -    / @bilingualanalytics  
ABOUT ME: https://bilingualanalytics.com.au/abo...
📍 – Sydney, Australia

📽 GEAR:
📷 – Canon EOS 200D
🎙 – Audio Technica AT2020
🔦 – Neewer 18” Ring Light
🎧 – BOSE QC35
🖥 – 2x ASUS VC279H
💻 – AMD Ryzen 3600, Gigabyte X570, GTX1650, G.Skill 32GB RAM

Music: www.bensound.com

#PowerBI #DynamicRLS #RowLevelSecurity #BILingualAnalytics #DataSecurity