Don't miss your chance to take the Fabric Data Engineer (DP-700) exam on us!
Learn moreWe've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now
Dears,
In our gold layer we have one semantic model per each workspace. Each workspace represents a domain
We would like to implement RLS in the semantic models so that users are subject to it
But we also, need to provide them build permissions as they will be doing self-service
Problem is that, if I am not wrong , if they have build permissions on the semantic model, then RLS is not enforced?
Or am I wrong?
What do you recommend for this?
Thanks,
Pedro
May I check if this issue has been resolved? If not, Please feel free to contact us if you have any further questions.
Thank you
Hi @fabricpribeiro ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.
Thank you.
Build permission does not bypass RLS, so users can safely be given Build access for self-service while still being restricted by RLS when querying the semantic model. The key point is that RLS is only bypassed for users with elevated workspace roles like Admin, Member, or Contributor, not for those with Viewer + Build.
you mean, even if I give explicit Build permissions in the semantic model itself? not via the item permissions, but via the Semantic model itslef, still , thye RLS created at semantic model will be respected, right?
Yes, even if you grant Build permission directly on the semantic model, RLS is still enforced. The only cases where RLS is not enforced are when users have elevated workspace roles (Admin/Member/Contributor).
Experience the highlights from FabCon & SQLCon, available live and on-demand starting April 14th.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 15 | |
| 9 | |
| 8 | |
| 5 | |
| 4 |
| User | Count |
|---|---|
| 35 | |
| 24 | |
| 14 | |
| 13 | |
| 12 |