Forum Discussion
Utilizing Power BI and Advanced Filtering
I see. This is interesting, but I see the max allowed users is 1,000. We do have around 40,000 users, mostly students so I suppose they wouldn't all need access to reports, but regardless, there are quite a few users.
More importantly though, the business rules are very complex, and we wouldn't be able to distill them down to these RLS items. We have an entire service that handles the rules of whether a user can access a particular report for a set of data, which are all dynamic and changing as well based on who is in which districts/courses/allowed access.
This is why I'm trying to take the approach of having our app provide the open/closing of the gate. Thank you for the suggestion though, I'm going to attempt to spike this idea out, but are you aware of any other features we could leverage to try what I'm describing?
I have implemented Dynamic RLS with about 10 000 users where there were only 3 Roles, and all the users were in one of those 3 buckets, based on the requirements. Where also quite complex due to the way the business was structured.
I am almost certain that it can be done, the challenge will be to ensure that the way it is setup is done in an efficient manner.