This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowThe Fabric community is now in read-only for platform upgrade. Learn more
I have a quick question about the number of RLS-Roles. Is there a limit to how many different roles I can set?
@freginier, Thanks for your answer. I have already seen this post. He is asking for a limit for emails. I am asking for a limit of how many different roles i can define.
Hi @MarcOhm ,
As far as we can tell, there is no limit on the number of roles in the official documentation.
In fact, you can set up multiple roles with one role. This is because rls can be set up dynamically.
https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
| User | Count |
|---|---|
| 23 | |
| 22 | |
| 14 | |
| 14 | |
| 13 |
| User | Count |
|---|---|
| 47 | |
| 39 | |
| 24 | |
| 20 | |
| 20 |