RLS error Join Paths are expected to Form a Tree.

[twister8889]

HI guys,

I have an error when I trying to use the RLS by Field. I understand the error message but I don't know how to solve this problem, can you please help me?

I have a table RLS Login, here I have the user@company.com

I have the dim2 that has a Key field  ( the same key into RLS Login

I have a Link table to connect the two facts tables ( I have measure1 and measure2 that using the cross filter both )

The error message is about the Link table and Fact1, Link table, and Fact2.

---If I change the relationship between the Link table and Fact1, Fact2 the problem is solved,

I think that is not a recommended solution.

Any suggestion to solve this problem?

This is my RLS CODE:

VAR _Code =

CALCULATETABLE (
VALUES (RLS_Login[Department]),
RLS_Login[Login] = USERNAME()
)
RETURN
OR(
"all" IN _Code,
dim2[Department] IN _Code
)

[Bi2thelly]

Has there been a resolution to this? I have a similar issue with RLS and geting the error when using two fact tables with a linked table in between.

[Anonymous]

Hi @twister8889 ,

According to my test, I think your issue appears in the direction of the two tables in the red circle in the figure below.

RLS login table flows to dim2 table, so that the row results filtered by RLS will be correct.

Best Regards,

Stephen Tao

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

[twister8889]

First of all,, thank you for your answer..

I needed to change the direction. Now, I have both, but the problem continue. When I inserted the Measure from table 1 and measure from table 2 into the same visual table, I have the error.

Join Paths are expected to Form a Tree.

Do I need to change my measures?