Power BI: Dynamic Security Using USERPRINCIPALNAME ()

In this video, Angelica will show you one way to simplify security management on a report, by utilizing the DAX function USERPRINCIPALNAME(). The way USERPRINCIPALNAME() works, is by capturing the identity of the user logged in and then filtering down the data in the report to only show what the user has access to. 👍 If you enjoy this video and are interested in formal training on Microsoft Teams, Power BI, Power Apps, Azure, or other Microsoft products you can visit https://prag.works/ANGELICA40 for 40% off On-Demand Learning! 00:00 - Recap of Basic Row Level Security in Power BI 01:21 - Challenges with Managing Multiple Roles Across Reports 02:06 - Introducing Dynamic Security Using USERPRINCIPALNAME() in DAX 02:45 - Exploring the Report Structure and Data View in Power BI Desktop 03:26 - Model View: Verifying Relationships Between Employee and Sales Tables 04:35 - Creating Dynamic Security Role in Power BI Desktop 05:12 - Testing Dynamic Security Role with View As Feature in Desktop 06:31 - Demonstrating Dynamic Security for Different Users 07:17 - Conclusion -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - Next step on your journey: 👉 On-Demand Learning - Start With The FREE Community Plan: https://tinyurl.com/2ujujsb5 🔗Pragmatic Works On-Demand Learning Packages: https://pragmaticworks.com/pricing/ 🔗Pragmatic Works Boot Camps: https://pragmaticworks.com/boot-camps/ 🔗Pragmatic Works Hackathons: https://pragmaticworks.com/private-training/hackathons/ 🔗Pragmatic Works Virtual Mentoring: https://pragmaticworks.com/virtual-mentoring/ 🔗Pragmatic Works Enterprise Private Training: https://pragmaticworks.com/private-training/customized-enterprise-training/ 🔗Pragmatic Works Blog: http://blog.pragmaticworks.com/ Let's connect: ✔️Twitter: https://twitter.com/PragmaticWorks ✔️Facebook: https://www.facebook.com/pragmaticworks/ ✔️Instagram: https://www.instagram.com/pragmatic.works ✔️LinkedIn: https://www.linkedin.com/company/pragmaticworks ✔️YouTube: https://www.youtube.com/pragmaticworks Pragmatic Works 7175 Hwy 17, Suite 2 Fleming Island, FL 32003 Phone: (904) 638-5743 Email: [email protected] #PragmaticWorks