Power BI RLS fails for specific measure sporadically.

[yash_sa]

Currently I have a measure which fails sporadically in power bi service when RLS is applied. It does not happen often.

Initially we had this "join path are expected to form a tree. Table has 2 paths" error only when the RLS was applied so as a solution we have added this line of code in our measure " CROSSFILTER(rls_bridge, dim_tbl, None).  This line of code hepls to deactivate the relation between rls_bridge and dim_tbl until the measure is executed.

Because of this line of code join path error is fixed. However, currently we have this failure "Failed to move the data reader to the next row" only on the measures which uses that CROSSFILTER condition and when RLS is applied. This issue do not happen frequently. Failure is sporadic. 

Could you please explain what might be causing this error and why it happens sporadically.

[Anonymous]

Hi  @yash_sa ,

The function in DAX is used to change the direction of a relationship in a calculationCROSSFILTER. However, it’s important to note that can only be used in functions that take a filter as an argumentCROSSFILTER. Also, if expressions are nested, and more than one expression contains a function, then the innermost is the one that prevails in case of a conflict or ambiguityCALCULATE CALCULATE CROSSFILTER CROSSFILTER. In some cases, using the function to activate your inactive relationship might be a better choiceUSERELATIONSHIP.

Best regards.
Community Support Team_Caitlyn