How to Set Up RLS in Power BI

Quick summary

Row-Level Security (RLS) in Power BI lets you restrict data access based on user identity by defining security roles and DAX filter expressions. Once configured, users assigned to a role see only the rows of data that match the filter criteria you set.

Steps

1. Navigate to the Modeling tab in the Power BI Desktop ribbon.
2. Select Manage Roles to begin setting up your Row-Level Security.
3. In the Manage Roles dialog box, click the + New button to create a new security role.
4. Give your role a descriptive name that clearly indicates its purpose.
5. Select the table that contains the data you want to filter.
6. Click Switch to DAX editor to create advanced filtering conditions using DAX expressions.
7. Enter your DAX filter expression in the editor.
8. Click Save to apply your RLS role configuration to the model.
9. A confirmation appears once you have successfully implemented Row-Level Security in Power BI.
10. Review how RLS filters data based on user identity — users assigned to this role will only see data that meets your filter criteria.