From the course: Microsoft Power BI Data Analyst Associate (PL-300) Cert Prep by Microsoft Press (2024)

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

Implement row-level security roles

Implement row-level security roles - Power BI Tutorial

From the course: Microsoft Power BI Data Analyst Associate (PL-300) Cert Prep by Microsoft Press (2024)

Start my 1-month free trial Buy for my team

Implement row-level security roles

“

- [Instructor] Okay, so in this sub lesson we're going to look how to implement row-level security roles. So first off, what is row-level security? Row-level security or RLS can be used to restrict data access for given users. Filters restrict data access at the row level, and you can define filters within those roles. Roles are implemented inside the Power BI desktop and role assignments are done in the Power BI service. So the configuration methods for row-level security. We can use what's called a static method, which uses a fixed value in the DAX filter. Or we could use the dynamic method, which uses a DAX function, which does not require continuous maintenance of the role. It uses the user principle name DAX function to determine the user principle name for a user. A UPN consists of a UPN prefix, which is the user account name joined with UPN suffix, which is the DNS domain name. And the example we have down below there is someone@example.com. And just for completeness sake…

Contents