thinQmaster Virtual testing partner Adaptive practice exams that find your weak spots and drill them. Every answer explained. From $69
Enroll

thinQmaster

Find your exam

Five questions free, before you decide.

Step 1 · choose a vendor

In one of our camps? Your practice exams come with the tuition — they are on your study page already.

Data & Analytics · Intermediate

Row-Level Security (RLS)

Restricting which rows a user can see based on their identity or role, enforced by the data platform or semantic model.

Definition

In Power BI, roles with DAX filter expressions are defined in Desktop and members are assigned in the Service. RLS applies to Viewers but not to workspace Admins, Members or Contributors. SQL Server and Azure SQL implement RLS with security policies and predicate functions, and Snowflake uses row access policies.

Example

[Region] = LOOKUPVALUE(UserRegion[Region], UserRegion[Email], USERPRINCIPALNAME())

Exam tip

Power BI RLS doesn't restrict users with edit permission (Admin, Member, Contributor) on the workspace.

Related terms