Row-level security problem

[Anonymous]

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? 

[v-lili6-msft]

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]

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

[v-lili6-msft]

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

[lbendlin]

This approach results in bad UX.

[lbendlin]

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]

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

[lbendlin]

show your data model.

[Anonymous]

This is how it looks like. 2nd screenshot shows the Role-level is applied to table sg0073.

[lbendlin]

Do you have to be able to filter "Mobile Bill" by "Terminated Lines" ?  That is not compatible with RLS.

[Anonymous]

No i dont need to do that, terminated lines is just a reference database which doesnt help much. In fact that database can be removed if not required. but can you explain why RLS wont work for that? 

[lbendlin]

RLS only works if filters flow FROM the RLS table, not TO the RLS table.

[Anonymous]

Hi,

Is this acceptable. Changed the filter direction.