How to Add Row-Level Security in Power BI

Guide

Start by navigating to the 'Modeling' tab in the Power BI Desktop ribbon. This is where all security-related options are located.
Now, select 'Manage Roles' to begin setting up your Row-Level Security. This opens the management interface for creating and editing security roles.
In the Manage Roles dialog box, click the '+ New' button to create a security role.
Give your role a descriptive name that indicates its purpose.
Select the table that contains the data you want to filter. This will be the table where your row-level security rules will be applied.
Click 'Switch to DAX editor' to create more advanced filtering conditions using DAX expressions. This gives you precise control over which rows users can access.
Enter your DAX filter expression.
Click 'Save' to apply your RLS role configuration to the model. This finalizes your security definition and makes it ready for testing.
Great job! Your Row-Level Security is now implemented. Remember to test it using 'View As' to ensure different roles see only their permitted data.

No credit card required • Start building today