Module 4 · DAX for harder questions Lesson 12 of 15
Row-level security: the right rows for the right person
Row-level security lets one report serve many people while each sees only their own region or team. The filter is a role you assign, applied by the service on top of the query.
Worked example
A role with a DAX filter dim_region[region] = USERPRINCIPALNAME() shows a manager their own region and nothing else, from the same file.
Your practice task
Create one region role, test it with "View as role", and note where you would assign people in the service.
Do this before moving on. Reading a solution teaches the shape of it; typing it teaches you.
Key takeaway
Row-level security lets one report serve many people while each sees only their own region or team. The filter is a role you assign, applied by the service on top of the query.
Keep your place in this course
A free account saves which lessons you have finished and unlocks the certificate. The lesson itself stays free to read.
Create free account or sign inCourse complete
You finished every lesson.
Your certificate is ready, and the projects you built are the proof to attach to an application.
Almost there
15 lessons left of 15
Finish every lesson to unlock the certificate. Each one ends in a practice task — do them and the final project brief writes itself.