Question about an error message in RLS setup

[leilei787]

Hello:

i need some helps to figure out why i got this error message. I am not sure if this is due to RLS or connections. thanks in advance!

i am working on a RLS project and could not load up a few datapoints. here is the error message i got:

here is my current setup and connection:

VW_fact_SerialNumberDetail (PrimaryGeoCode_c) -----GeoMapTranslations table ( through Territory Num)

VW_fact_SerialNumberDetail (ShiptoCustAccountNumber) -----Account Table ( AccountNumber)

VW_fact_SerialNumberDetail (Region Name) -----User SFDC ( Region) this is many to many relationship

User SFDC is for RLS purpose....i currently set it up as many to many relationship to the fact table because we want territory manager to see the whole region, not just their own territory. so i connect region so that it will filter by region when user login to PBI

[Anonymous]

Hi @leilei787 ,

This problem maybe cause by your relationships, according to the error, the table named "VW_fact_SerialNumberDetail" have two path to table "User SFDC", please try to adjust your model.

Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.