Forum Discussion
RLS Not Displaying Visual due to Join Paths
Hi guys, trying to create RLS security, but when I try to view as the user, all my visuals give me an error code. The RLS security formula is based on the "Location Master Data" table. See below....
v-lili6-msft
Community Support
Community SupportHI,@sam514
After my research, You can change Cross filter direction to single when creating the relationship
between Total sales and Facts orders. and then it will ok.
here is the reference:https://community.powerbi.com/t5/Desktop/Join-paths-and-relationship/td-p/278754
Best Regards,
Lin
Hi there,
When changing the cross filter direction to single, I get an error code: "You can't create a direct active relationship between Facts Orders and Total Sales because that would introduce ambiguity between tables Total Sales and Product Details. To make this relationship active, deactive or delte one of the relationships between Total Sales and Product Details first."
Let me know! Thanks.