Forum Discussion

JohnLow's avatar
JohnLow
Icon for Helper I rankHelper I
5 years ago
Solved

Row Level Security Question

Hi,   I'm new to RLS and need a little help. I've 3 tables Users, Network and Sales. Users has a relationship to Network which in turn has a relationship to Sales. Users have 3 roles: Network User,...
Need Help
  • sayaliredij's avatar
    sayaliredij
    5 years ago

    Hi JohnLow 

     

    Could you try applying a security filter

     

    I tried at my end and it works

     

    For Finance user - everything is visible and for network user - only data related to him

     

     

sayaliredij's avatar
sayaliredij
Icon for Solution Sage rankSolution Sage
5 years ago

You can create 2 roles 

1. Admin Role - where you can put all the people who would have access to all numbers 

2. Network role with DAX Formule = [Username] = USERNAME()

 

In power bi service while defining RLS configuration for Admin Role - you can put all the people from administrator and finance and for other network role - people from network departments (all other people)