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-tr...
🔗Pragmatic Works Virtual Mentoring: https://pragmaticworks.com/virtual-me...
🔗Pragmatic Works Enterprise Private Training: https://pragmaticworks.com/private-tr...
🔗Pragmatic Works Blog: http://blog.pragmaticworks.com/

Let's connect:

✔️Twitter:   / pragmaticworks  
✔️Facebook:   / pragmaticworks  
✔️Instagram:   / pragmatic.works  
✔️LinkedIn:   / pragmaticworks  
✔️YouTube:    / pragmaticworks  


Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: (904) 638-5743
Email: [email protected]
#PragmaticWorks