Row level security

[Sravani228]

Hi ,
I’m new to power bi ,facing few issues please help,
Created row level security for 3 levels , working correct for level 1 but for level 2 and 3 I can still see level 1 which I’m not intrested .
Thanks
Sravz

[Sravani228]

Hi ,
I’m new to power bi ,facing few issues please help,
Created row level security for 3 levels , working correct for level 1 but for level 2 and 3 I can still see level 1 which I’m not intrested .
Thanks
Sravz

[Sravani228]

Hi ,
I’m new to power bi ,facing few issues please help,
Created row level security for 3 levels , working correct for level 1 but for level 2 and 3 I can still see level 1 which I’m not intrested .
Thanks
Sravz

[Sravani228]

Hi ,
I’m new to power bi ,facing few issues please help,
Created row level security for 3 levels , working correct for level 1 but for level 2 and 3 I can still see level 1 which I’m not intrested .
Thanks
Sravz

[Sravani228]

Hi ,
I’m new to power bi ,facing few issues please help,
Created row level security for 3 levels , working correct for level 1 but for level 2 and 3 I can still see level 1 which I’m not intrested .
Thanks
Sravz

[Sravani228]

please some one respond to my post....

[Anonymous]

Please provide more details, preferably with screenshots and dummy data.

[Sravani228]

Thanks for your reply much appreiciated.

I have created row level security for ceo,manager and line manager.when am trying to apply the ceo email id  i can able to see all that who works under the ceo i,e manger and line manger and the count is also working perfect.while am trying to apply rls for manager level it is also working perfect in terms of count but it first showing ceo and then showing manager in the tree map visualisation whereas i wanted to appear manger straight away in the treemap when i apply the email of manger.

as i cant provide the data and screen shots becuse of dat asecurity reasons.

hope you got my issue.

Many Thanks,

sravz

[Anonymous]

Can you please try this approach.

[Sravani228]

PATHCONTAINS(
[Hierarchy],
LOOKUPVALUE(tbHeadCount[POSUserID],
            tbHeadCount[Email],
USERPRINCIPALNAME()
           )
           )

used this dax to filter and get the count correct.i am getting the count correct for every level  level but when am trying to see the visualisation its been showing all the levels from starting.for ex i logged in as manager the count is correct but it showing ceo first then if i drill down am seeing manger which i dont want...

am i clear please bear me in explaining things....

[Sravani228]

Hi @Anonymous

Can u please respond and help me in this.....