Forum Discussion
RLS not working
Hi Everyone,
I have created two roles as Manager and Non Manager where I have assigned some of the people to Manager and Non Manager. After I have assigned people to the Power BI service and tested as a role using the email Id but it is not working. Even the Non manager is able to see all the data.
Can anyone please help me with this.
Thanks in Advance.
6 Replies
- amitchandakSuper User
kamalbandam , Hard to say, without looking at the configuration setting. Can you share more details.
Also, refer these two for any missing steps
https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi
https://www.blue-granite.com/blog/using-dynamic-row-level-security-with-organizational-hierarchies- kamalbandamHelper III
Hi amitchandak ,
Manager will see all the regions data but Non Manager will not see the Region "East" data and a person [email protected] has been assigned to the Non Manager data in the power bi service. So, when I try to check using Test as role with [email protected] , I am able to see the east data too.
Please find the below images:
- Greg_DecklerCommunity Champion
kamalbandam - Would need to see your RLS rules and such. Have you been following something like this: