set_rls
Set or update row-level security (RLS) filters for roles on tables using DAX boolean expressions, restricting rows to those that return true. Creates missing table permissions automatically.
Instructions
Set or update the row-level security (RLS) filter for a role on a table. The DAX boolean expression keeps only the rows it returns true for, e.g. "[Region] = USERPRINCIPALNAME()" or "'Sales'[Country] = "NZ"". Creates the table permission if absent.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| role | Yes | role name (create with add_role first) | |
| table | Yes | table the filter applies to | |
| sessionId | Yes | ||
| daxFilterExpression | Yes | DAX boolean filter expression |