Forum Discussion
RLS and USERELATIONSHIP problem
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.
Hi AlexNL ,
Since this is an knonwn issue from Microsoft end , as of now the team has suggested to follow the below approach :
" To fix the issue, customer can remove CROSSFILTER and USERELATIONSHIP from their measures. Alternatively, customer can modify the relationships as per public documentation recommendations for RLS models.
Active vs inactive relationship guidance - Power BI | Microsoft Learn
Dynamic row-level security with Analysis services tabular model - Power BI | Microsoft Learn
USERELATIONSHIP function (DAX) - DAX | Microsoft Learn
If the customer is reporting the issue accessing PowerBi reports with error:
"The USERELATIONSHIP() and CROSSFILTER() functions may not be used when querying 'T' because it is constrained by row-level security".
If this helps, please consider marking it 'Accept as Solution' so others with similar queries may find it more easily. If not, please share the details.
Thank you.
Hi v-aatheeque
Is there any news?
Hi AlexNL ,
Thank you for following up. we wanted to provide an update that the issue is still under investigation and has not yet fixed.
We sincerely appreciate your patience and understanding. we will keep you updated with any progress.
Is there any update on the investigation and when we can expect a fix?
Hi wdv72 ,
Apologies for the issue.
Still the issue is in active state , please refer the below link for reference :Known issue - Reports that use functions with RLS don't work - Microsoft Fabric | Microsoft Learn
