Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

RLS and hierarchy

Dear all,

 

Currently I'm working on a dashboard that has a hierarchy and RLS. The hierarchy contains 10 levels.

The users are limited to only see the levels they're assigned to. The catch, however, is that the levels above the lowest level they can see should remain fully populated. My data is coming from Teradata with import function.

 

A simplified structure looks like this:

Level1Level2Level3Value1Value2
AAAAAA105%
AAAAAB202,50%
AABABA102,52%
AABABB101,44%
AACACA202%
AACACB303,50%
BBABAA256,10%

 

In the visual that would be (value1 sum, value2 avg)

LevelValue1Value2
A1002,83%
AA303,75%
AAA105,00%
AAB202,50%

 

 

Let's say we have user John, John was assigned level3 AAB and ABA. With RLS up and running, he'll only see:

 

Level1Level2Level3Value1Value2
AAAAAB202,50%
AABABA102,52%

 

LevelValue1Value2
A302,51%
AA202,50%
AAB202,50%
AB102,52%
ABA102,52%

 

However, what I want John to see:

 

Level1Level2Level3Value1Value2
AAAAAB202,50%
AABABA102,52%

 

LevelValue1Value2
A1002,83%
AA303,75%
AAB202,50%
AB201,98%
ABA102,52%

 

So, what Power BI does, is take the lower levels to 'construct' the higher levels. By applying RLS, not all levels are available and thus, not all data to create the correct numbers.

 

What I'm looking for, is a way to 'visually' limit the levels for the user and not limit the data.

Alternatively, I can have my values per level determined on data side. In that case I would need a way to have a hierarchy in Power BI without it applying 'logics' to my data.

 

Thanks in advance.

1 Reply

  • v-lili6-msft's avatar
    v-lili6-msft
    Icon for Community Support rankCommunity Support

    hi, Anonymous 

    If you want to 'visually' limit the levels for the user and not limit the data,

    you could apply the logic in the measure and use it in visual level filter.

     

    Best Regards,

    Lin