Bypass RLS through DAX in Manage roles section
Hello Community, In our dashboard are currently using RLS (user email = userprincipalname()) to show data based on the logged in user. Now, we need to bypass this RLS when the user is from "Admin" team. I have pasted below the sample data: user id user name user email Team 1 A [email protected] Admin 2 B [email protected] Employee 3 C [email protected] Employee 4 D [email protected] Employee 5 E [email protected] Employee 6 F [email protected] Admin For Example: when user A or F logs in then RLS should not be applied i.e. The user should be able to see all data. when the other users except A and F log in , they should see only their data. Please can someone help in this regard. Thanks, AnthonyJoseph