cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
delaclqm Frequent Visitor
Frequent Visitor

RLS Test As Role shows different for user

Hello all, 

 

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.

 

My View: 

My View of the RLS RolesWhat I see testing as user's role

What the User Sees...

What the user sees on the Power BI service

4 REPLIES 4
Super User
Super User

Re: RLS Test As Role shows different for user

Hi there

Can you make sure that the user you assigned to the role is the same user account that is being logged in?

Did I answer your question? Mark my post as a solution!

"Proud to be a Datanaut!"


Power BI Blog
delaclqm Frequent Visitor
Frequent Visitor

Re: RLS Test As Role shows different for user

@GilbertQ 

Yes, I know for a fact it is the same user, which is what has me so confused.

Super User
Super User

Re: RLS Test As Role shows different for user

What if you remove the user and then add them again to both the RLS and App?

Did I answer your question? Mark my post as a solution!

"Proud to be a Datanaut!"


Power BI Blog
delaclqm Frequent Visitor
Frequent Visitor

Re: RLS Test As Role shows different for user

@GilbertQ 

 

Yes I tried both of those and still no luck, I am just going to submit a support ticket to Microsoft.

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Users Online
Currently online: 205 members 1,651 guests
Please welcome our newest community members: