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.

AlexNL's avatar
AlexNL
Advocate II
1 year ago

We've got the same issue here. Can somebody please confirm if this issue is a bug or not?

 

In my opinion it is a clear bug. It was working fine before and very very helpful and needed. All the community responses confirm this. Also when you test this in Power BI Desktop it all works fine(!). This issue only occurs in Powerbi.com. It is just not logical.

 

EDIT: We do not have the latest Power BI Desktop release. When we install this the problem will probably occur also local (desktop).