RLS and USERELATIONSHIP problem

[ju97]

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 ‘TableA’ because it is constrained by row-level security defined on ‘TableA’ or related tables"

I'm aware of this error and why it occurs, but the report has been working fine, hasn't had any major changes recently, and this issue has only appeared over the weekend.

Can you please confirm if you are aware of that issue and if we can expect some help from you?

[mostvp123]

Same issue. Is affecting crucial report. 

[Madsdreyer]

We have this issue as well.

[wdv72]

Unfortunately we also encountered this problem. We use the userelationship with rls to separate 2 groups from which one is not able to see certrain private data and the other group is able to see the data. Now the reports only show the error. 

Microsoft please fix this as there is no other possibility to secure our data without unwanted replicating tables is our semantic models.

[v-aatheeque]

Hi @wdv72 ,
Apologies for the issue you are facing.
The product team has taken note of the situation and is working on it, if there are any new developments we will reply below.
Appreciate your patience.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[ElsDEs]

I added a bug https://community.fabric.microsoft.com/t5/Service/Sudden-RLS-and-USERELATIONSHIP-problem/m-p/4367400... 

hope this helps ...

[dhoskins]

Same issue for me, no changes made to the report but since the weekend it displays this error across visuals in our report on the service and embedded in our SaaS platform.

When testing RLS roles in desktop, no errors are displayed

[wdv72]

Same here, but we are on novermber PBI desktop. saw errors mentioned in the january PBI desktop version...

[Idrissshatila]

Hello @ju97 ,

i didn't see such issue here so far, but you can open an issue that will be investigated by microsoft support and they will assist you if this is a bug https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues/tab/most-recent

[robertnorman]

Any more suggestion?

[robertnorman]

This is indeed a bug. If you are a super user why dont you help reporting it. Your link leads to a "New Idea"-request. Sure will try that as well, (but we all know that wont help - quickly).