Скачать с ютуб Dynamic Row-level Security 🔐 - Based on Dimension Tables в хорошем качестве

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