Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Filter a barchart - row level security

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

Need Help
Show and Tell
  • dax's avatar
    dax
    6 years ago

    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.

7 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    6 years ago

    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's avatar
      Anonymous
      Not applicable
      6 years ago

      The relationship is already setup as one to many.

      • dax's avatar
        dax
        Icon for Community Support rankCommunity Support
        6 years ago

        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.