How to implenent Dynamic RLS in Power BI Projects

1. Create a User Mapping Table
   Prepare a table (from Excel or SQL Server) that maps users to specific data segments.                                                                                                                   

   UserEmail	Region
   [email protected]	East

    
2. Load Data into Power BI
   Import both your main data (e.g., sales data with a 'Region' column) and the user mapping table into Power BI.
3. Establish Relationships
   Create a relationship between the 'Region' field in both tables:

               UserAccess[Region] → SalesData[Region]

       4. Define RLS Roles in Power BI Desktop

           Navigate to Modeling → Manage Roles.

           Create a new role (e.g., 'RegionalAccess').

           Apply the following DAX filter on the 'UserAccess' table:

           DAX

           [UserEmail] = USERPRINCIPALNAME()

           5. Test the Role
           Use Modeling → View as Roles to simulate and verify the RLS behavior for different users.

           6. Publish and Assign Roles in Power BI Service

• Publish the report to the Power BI Service.
• In the workspace, go to Datasets → Security.
• Assign users to the defined roles.

Refer these links for more details,

• Implement Row-Level Security in Power BI
  Comprehensive guide on setting up both static and dynamic RLS:
  🔗Implement Row-Level Security - Microsoft Learn
• Row-Level Security (RLS) with Power BI
  Detailed documentation on RLS concepts and configurations:
  🔗Row-Level Security with Power BI - Microsoft Fabric