Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Haim_is
Frequent Visitor

RLS Problem

Hi

I use RLS and use one of the fields in the database called department.
When I do a simulation everything seems fine. I do the same simulation also in service after I connected the department and the user and everything seems fine.
The problem is when the user logs in he sees all of the Department's and not just his.
Do you have any idea why this is happening?

 

Tnx Haim

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @Haim_is ,

Please check whether that user who can see all department info have the edit permission of the related workspace? The workspace is which the report located in. RLS roles will not be applied to the users who have the edit permission of the workspace... You can find the details in this official documentation.

Best Regards

Rena

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

Hi @Haim_is ,

Please check whether that user who can see all department info have the edit permission of the related workspace? The workspace is which the report located in. RLS roles will not be applied to the users who have the edit permission of the workspace... You can find the details in this official documentation.

Best Regards

Rena

Hi  Rena

 

You are right  some of the users had  edit permission.

Acknowledge and appreciate your help.

Best Regards 

 

Haim

 

 

Greg_Deckler
Community Champion
Community Champion

@Haim_is - Sounds like the user is either not added to the right RLS role or something along those lines.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.