Forum Discussion
Solved
Directlake Row Level Security
I'm running into an issue applying RLS to a DirectLake model, where I receive the error "The user belongs to multiple roles '' that have security filters, which isn't supported when one of the roles ...
steveplatz2 Current Workarounds
To avoid the error:Combine all RLS logic into a single role, or
Refactor the model to avoid N:N security filtering when multiple roles must be allowed, or
Use Import or DirectQuery mode, which do support merging RLS roles.
please mark this solution. Thanks
Thank you for the reply. I assume there is no workaround for this limitation today? Any chance you know if correcting this is something that's on their roadmap?
steveplatz2 Current Workarounds
To avoid the error:
Combine all RLS logic into a single role, or
Refactor the model to avoid N:N security filtering when multiple roles must be allowed, or
Use Import or DirectQuery mode, which do support merging RLS roles.
please mark this solution. Thanks