Security: workspace roles, item permissions, RLS, CLS and OLS
- Workspace Admins, Members and Contributors can edit a semantic model, and anyone who can edit a model bypasses its row-level and object-level security, whatever roles they belong to.
- Row-level security roles filter tables with a DAX filterExpression, and the filter flows along relationships, so a filter on a Region dimension also restricts every fact table related to it.
- Object-level security sets metadataPermission to none on a table or column, so the object is hidden from the role entirely and any visual or query that references it returns an error.
- Roles are additive: a user in two roles sees the union of what both allow, so adding a role with no filter silently removes the restriction another role imposed.
- In a warehouse, column-level security is GRANT SELECT on named columns and row-level security is a security policy with a predicate function, both enforced on every T-SQL query.