Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
What should be my next steps?
HI,@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.
User | Count |
---|---|
107 | |
89 | |
81 | |
76 | |
73 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |