How to Implement Row-Level Security in Power BI

Quick summary

Row-Level Security (RLS) in Power BI lets you restrict data access at the row level by assigning DAX filter rules to user roles. Once configured, each role only sees the data permitted by its filter — for example, limiting a role to a single region's records.

Steps

1. Go to the Modeling tab in Power BI Desktop.
2. Click Manage Roles to open the role management window.
3. In the Manage Roles window, click + New under the Rule section to create a new rule.
4. Give the role a descriptive name.
5. Pick the table you want to filter data from.
6. Click Switch to DAX editor to enter a custom filter expression.
7. Type the DAX formula to define which rows the role can access.
8. Click Save to apply your changes.
9. A confirmation message appears once Row-Level Security has been successfully implemented.
10. Verify the role is working — this role will only display North region data based on the filter set.