Forum Discussion
Dynamic RLS based on two columns
Anonymous You could create two RLS roles
RLS which would be used for all people with single entity accessand 'No RLS' role like this:
When you publish the report, put all users responsible for the whole sales sector under this 'No RLS' role, and they will be able to see all the data, as effectively for them the RLS is not applied as the restriction of 1=1 is always true, thus will be seeing all the rows.
Hope this helps
RLS rules apply to the entire table (the "R" in RLS) as opposed to CLS rules that Power BI doesn't support yet.
You can make the rule as complex as you want, even including related tables. Don't go overboard though - RLS is costly from a performance perspective.
You are right that RLS seems to slow down the reports significantly. In addition to creating a customized user acess based on a table. How can I give some super users access to the whole dataset? I don't want to include those super users to the access table because that will add many lines to the table and slow down the filtering speed.
Anonymous You could create two RLS roles
RLS which would be used for all people with single entity accessand 'No RLS' role like this:
When you publish the report, put all users responsible for the whole sales sector under this 'No RLS' role, and they will be able to see all the data, as effectively for them the RLS is not applied as the restriction of 1=1 is always true, thus will be seeing all the rows.
Hope this helps