Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a user table with User emails assigned to ID. Subsequent tables linking User IDs to records. RLS is working great by matching USERPRINCIPALNAME() to email.
I am wanting to return no records if the USERPRINCIPALNAME() in not found in the user table emails.
Is this possible?
Solved! Go to Solution.
Based on the DAX condition you have setup, if the value returned by USERPRINCIPALNAME() doesn't exist in the table, the condition won't be satisfied which means no records will be returned and hence the user won't be able to see anything from that table.
In other words, what you are wanting works by default.
Based on the DAX condition you have setup, if the value returned by USERPRINCIPALNAME() doesn't exist in the table, the condition won't be satisfied which means no records will be returned and hence the user won't be able to see anything from that table.
In other words, what you are wanting works by default.