Row-Level Security (RLS)

Row-level security (RLS) is a form of data governance that empowers developers and administrators to restrict an end-user's data visibility within a Power BI report or dataset, determined by the logic applied at the individual row level.

Powerops simplifies the security role information by breaking it down into a user-friendly table, making it easy to comprehend and manage.

User Interface

  1. Count of RLS Roles - View the number of RLS roles defined in the report.

  2. Role Name - Shows the name of the security role

  3. RLS Type (Static/Dynamic) - Static RLS - Suitable for simple scenarios where the access rules are straightforward and do not change frequently. Dynamic RLS- Appropriate for complex scenarios where the access rules need to be updated frequently and automatically.

  4. Table Reference - Displays the name of the table on which the security role is created

  5. Filter Expression - The expression logic according to which the field will be filtered

  6. Column Selector - Choose all the necessary columns to be viewed from the dropdown menu.

  7. Download Button - Export the Row-Level Security (RLS) information in either CSV or Excel format.

Last updated