Forum Discussion
alfBI
Responsive Resident
9 months agoRLS Expression Evaluation Failed - Failed connection
Hi everyone, We are implementing a RLS on a semantic model on a Table (e.g: Table A) . This RLS requires to check if a given row exists on a table (we will name TableRLS) in orde to decide if use...
- 9 months ago
Hi,
By the way it looks like we have been able to manage the issue applying a less drastical approach that implied:
1) Optimize DAX RLS Expression
E.g:Before
VAR AllowedDocs = SELECTCOLUMNS( FILTER( 'RLS_Document', LOWER('RLS_Document'[EmailAddress]) = LOWER([FixPBIUsername]) ), "DocID", 'RLS_Document'[Document UID] ) RETURN IF( DimDocVersion[Has RLS ?], DimDocVersion[Document UID] IN AllowedDocs, TRUE() )After
IF ( NOT DimDocVersion[Has RLS ?], TRUE(), CALCULATE ( COUNTROWS ( FILTER ( 'RLS_Document', 'RLS_Document'[Document UID] = DimDocVersion[Document UID] && 'RLS_Document'[EmailAddress] = [FixPBIUsername] ) ) ) > 0 )2) Implement Query Caching and Large semantic model (oour model has a size about 1 GB, so its a good candidate)
After these changes no more errors has been raised. Let's see if this is the final solution or issue re-appears. In such a case we will towards change the model import+directquery towards a import+direct lake.
Regards
v-hashadapu
Community Support
9 months agoHi alfBI , Hope you are doing well. Kindly let us know if the issue has been resolved or if further assistance is needed. Your input could be helpful to others in the community.