Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
85 | |
84 | |
67 | |
63 | |
63 |
User | Count |
---|---|
208 | |
121 | |
112 | |
79 | |
71 |