Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Row-level security problem

Hi,

I intend to change a view of a particular visualization to row level security and its works when tested. 

However the other charts are showing full percentage for example the department should be showing a breakdown of all the departments regardless of the filter however it shows as the department over the rest as 100 percentage (top left chart).

How can we change it? 

 

 

 

Need Help

12 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    6 years ago

    Make sure your RLS table sits at the top of the data model hierarchy (ie the outskirts of the star/snowflake) and that the filter direction only points from the RLS table to the sub dimensions and fact tables, not the other way round.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Sorry can you explain what you just said, im still learning the ropes here. Pardon my noobness hehe.

  • v-lili6-msft's avatar
    v-lili6-msft
    Community Support
    6 years ago

    hi  Anonymous 

    RLS will work on your data mode level, not report visual level.

    so after you apply RLS, the datamolde will be filtered, in your case, your department will only have IT in the data mode.

    so whatever dax you used, it will still keep 100% for IT in the visual.

     

     

    Regards,

    Lin

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Is there anyway to hide unncessary visuals specific for that role?

      • v-lili6-msft's avatar
        v-lili6-msft
        Community Support
        6 years ago

        HI  Anonymous 

        It could not hide a visual by role in power bi for now.

        and as a workaround, you could create a measure as below

        Measure = IF(USERPRINCIPALNAME()="Role",1,0)

        Then drag this measure into that unncessary visual's visula level filter and set is "1",

        In this way, this visual will show blank for that role.

         

        Regards,

        Lin