cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Mohsen_2020
Helper III
Helper III

RLS is working in Power BI Desktop but not in service

Dear Team, 

It's about RLS, i tested the RLS in Power BI Desktop and it's working perfect but not working at all after publishin to Power BI Service.

suppose that Manager will see his team numbers only so when i make the access in the workspace access as "Viewer"  or Member its giving the below message. 

ss01.png

and when i change the access to "Contributer" manager can view the whole teams data not only his team. 

Please advise. 

Regards,

Mohsen

 

1 ACCEPTED SOLUTION

Hi @Mohsen_2020 

you have to assign him a role in the Security menu.

 

https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls#manage-security-on-your-model

dataset-more-options-menu.png

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener work at KUMAVISION AG , one of the world's largest
implementation partners for Microsoft Dynamics. #
"Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website


View solution in original post

3 REPLIES 3
mwegener
Super User
Super User

Hi @Mohsen_2020 ,

 

RLS only applies to the "Viewer" role. Have you also assigned the user to his corresponding RLS role?

 

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener work at KUMAVISION AG , one of the world's largest
implementation partners for Microsoft Dynamics. #
"Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website


could you please elaborate more about this? i assigned the user as showind in the below screenshot, did i missed something?

ss02.png

Hi @Mohsen_2020 

you have to assign him a role in the Security menu.

 

https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls#manage-security-on-your-model

dataset-more-options-menu.png

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener work at KUMAVISION AG , one of the world's largest
implementation partners for Microsoft Dynamics. #
"Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website


Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May 23 2022 epsiode 5 without aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

Power BI Dev Camp Session 22 with aka link 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!