Insights / RLS in Power BI / Part 3
Part 3 of 20 · Share itWhy RLS doesn't work for Contributors in Power BI
The problem. Your RLS is correct and "Test as role" passed. Your finance manager still sees every region.
Why. RLS only applies to people who read the model: workspace Viewers, and people who get the report through an app or a share. Workspace Admin, Member and Contributor can edit the model, so RLS is skipped for them. "Test as role" won't show you this, because it applies the role to whoever you pick, whatever their real access is.
Build is not Write. Build lets someone create their own report or use Analyze in Excel on your model. RLS still applies to Read, Build and Reshare. It is skipped for Write.
| Access | Can do | RLS applies? |
|---|---|---|
| Workspace Viewer | Read reports | Yes |
| Model Build / Reshare | Build reports, share | Yes |
| Workspace Contributor | Create, edit, publish | No |
| Workspace Member | Contributor + add people | No |
| Workspace Admin | Everything | No |
The fix. Someone wants to build on your model or share it? Don't change their workspace role.
Semantic model → Manage permissions → add their email or security group → tick Build (and Reshare if needed).
Admin, Member and Contributor are for the people who build the workspace. Everyone else gets Viewer or the app.
Check before go-live
- Business users are Viewers or app users, not Contributors or Members Service
- People who build on the model have Build permission, not a higher workspace role Service
- Nobody outside the build team has Write on the model Service
Want a second pair of eyes on your own model? The RLS review checks your roles, relationships and workspace access against this checklist, at a fixed price.