Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi
I have a requirement. I need to implement RLS but i have two join paths.
I have a user table which is connected with Assign table via User Id = Assignee. I can create a role and when user id 1 logs in he can see the Assign table details.
If user id 2 logs in there is no matching Assignee record in Assign table so it should take the another join path i.e. User -> Class -> Work -> Assign
I can't use USERELATIONSHIP.
My requirement if Assign is null it should choose another join path (inactive relationship) other wise regular path (active relationship)
Solved! Go to Solution.
So based on your senario, in the role rule, if relationship between User and Class is activated, the relationship between User and Assign should be inactived, right? I'm afraid this couldn't be achieved because dax function can't inactive a relashonship between two tables.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi - I have the exact same scenario.
Was just wondering if, some 4 years later, the same answer is true that it can't be done?
Could USERELATIONSHIP not be utilised somehow?
Thanks in advance.
So based on your senario, in the role rule, if relationship between User and Class is activated, the relationship between User and Assign should be inactived, right? I'm afraid this couldn't be achieved because dax function can't inactive a relashonship between two tables.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
96 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |