Forum Discussion
Row Level Security based on organisation structure - multiple conditions
Hi Anonymous
Thank you very much for your reply.
The formula is very close, but two users are not getting the expected results.
- it picks up 3 records rather than 2.
- Expected result - it should not include Singapore.
- it picks up 2 records rather than 5.
- Expected result - it should only exclude record where DC + Result + HR + HR Manager.
Kind regards,
IzBell
Hi IzBell ,
For the above scenario for [email protected]
- This was happening because your email has multiple access entries in the RLS table (e.g., one for Canada and one for USA). However, the previous rule was only picking one row instead of combining them.
[email protected] seeing 2 records instead of 5
- This user had several exclusion conditions like Team, Org Unit, Role, etc. Earlier, these were getting mixed together, which caused valid rows to be hidden.
- Ensure that each exclusion rule is treated separately data is only excluded if it matches all conditions from any one exclusion row, which is the correct behavior.
Hope this helps !
If this post was helpful, please consider marking Accept as solution to assist other members in finding it more easily.
If you continue to face issues, feel free to reach out to us for further assistance!
Hi IzBell ,
We haven’t heard back from you regarding our previous response and wanted to check if your issue has been resolved.
If it has, please consider clicking “Accept Answer” and “Yes” if you found the response helpful.
If you still have any questions or need further assistance, feel free to let us know — we're happy to help!Thank you!
Hi IzBell ,
Hi @nanacobsbs ,
Has your issue been resolved? If a community member's response addressed your query, please consider marking it as Accepted Answer and click Yes if you found it helpful.
If you have any further questions, feel free to reach out.
Thank you for being a valued member of the Microsoft Fabric Community Forum!Hi IzBell
just checking in on your query regarding Row-Level-Security-based-on-organisation-structure-multiple.
If his suggestion helped resolve the issue, please consider marking it as the Accepted Answer, as it can be useful to others who may face a similar situation.
Should you still need assistance or have further questions, feel free to reply with more details — we're here to help.
Thanks once again for being part of the Microsoft Fabric Community!