Filter a barchart - row level security

[Anonymous]

I plan to show to our users in the company their usage of Email and Teams. As the information is senssitive I plan to use the row level security.  This is sorted out.

But I am struggeling in the dashboard that the visual shows always the number for all users or nothing.

The Filter at the left I do not want to use. 

UserNameVisual which should be filteredUserActivity

[lbendlin]

You will want to wire your RLS dimension table to the facts table (with the consumption details) in a 1:M relationship (based on UPN column)

[Anonymous]

The relationship is already setup as one to many.

[dax]

Hi  @Anonymous ,

If you want to use UPN to filter it, I think you don't need user name table, you could try to use role setting like below to see whether it work or not

 Then set security in service, you could refer to service-admin-rls  for details.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

I changed according to your recommendations. After applying the setting the information is still not visible for the user. By applying view as the values are empty. raw data informationvisual after appying the "show as" role May be the data setup is not correct?

[Anonymous]

It does not work either.  I uploaded the Workbook here https://we.tl/t-FaDidJUe0n . May be you can check it?

[dax · Accepted solution]

Hi @Anonymous , 

You could refer to my sample.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[dax]

Hi @Anonymous , 

The USERPRINCIPALNAME ( ) will return current user's UPN, so you need make sure whether current user's UPN(you could use this function to check it) is user5@compamy.com. It is, you could set below to see whteher it work or not

If it is not user5@company.com, you could set like below to see whether it work or not.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.