Forum Discussion

ju97's avatar
ju97
Advocate I
1 year ago
Solved

RLS and USERELATIONSHIP problem

A long standing report has recently had a large majority of visuals show the error when RLS controlled users access: "The UseRelationship() and CrossFilter() functions may not be used when querying ...
General Comment
Need Help
  • v-aatheeque's avatar
    v-aatheeque
    1 year ago

    Hi ju97,

    Thank you for bringing this issue to our attention. We understand that the error related to the UseRelationship() and CrossFilter() functions has recently impacted your report, despite it functioning well previously.

    As this is a known issue that is currently being addressed, we are unable to keep this thread open indefinitely.For official updates, you can check for more information through the provided link : Known issue - Reports that use functions with RLS don't work - Microsoft Fabric | Microsoft Learn

     

    In the meantime, if you continue to experience difficulties, we kindly encourage you to create a new thread. This will allow us to assist you more effectively.

    Thank you for your understanding, and please know that we are here to help!

     

    Best regards,
    Atheeq.

Col_Mar's avatar
Col_Mar
Advocate I
1 year ago

Our model does not have RLS directly defined on the table in which the measure is included (we have a seperate measures table anyway) but its like the security filter is now not working as it was?  
We also cannot replicate the issue in Desktop by impersonating the RLS user so it feels like if this was intended behavoir it would also give the same error?