So I have run into a very odd issue that I cannot seem to figure out. So I manage the dashboards for my company and within the company, we have implemented RLS for each sales person's region that way they can only see their own sales metrics. It has been working very well for some time now, but now I have run into the issue where one of the sales people have data missing from their RLS view, but when I use the "Test as Role" for his territory on the Power BI Desktop app and on the Power BI service, all the proper data shows up.
Now, correct me if I am wrong, but when I test as his security role, I should see exactly the same dataset as he sees from his account, correct? We have over 20 sales people which means we have over 20 roles set which are set using security groups that are set in our AD (I will however be migrating to setup roles based on username, but there need to be changes implemented on our local servers before that can be implented).
Below are screenshots of what the user sees on his end vs what I see when I test as his role. Has anyone else run into this issue/know how to solve it?
Please note, I have blocked some data using boxes in order to keep company data confidential, but please look at the red boxes and the last couple digits of the data to verify what data is the same and what is different.