Forum Discussion

thebigwhite's avatar
thebigwhite
Helper II
6 years ago
Solved

RLS Best Practice

Good afternoon,  I am asking for an advice on what is the best approch concerning the RLS for a multi "Branch" scenario.  Scenario:  I have a model where there is a fact table and then there are o...
Need Help
Tips and Tricks
  • v-lionel-msft's avatar
    v-lionel-msft
    6 years ago

    Hi thebigwhite ,

     

    Try to create a model like this.

    Then create a role on the 'Branch table'.

     

    Best regards,
    Lionel Chen

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

v-lionel-msft's avatar
v-lionel-msft
Community Support
6 years ago

Hi thebigwhite ,

 

Try to create a model like this.

Then create a role on the 'Branch table'.

 

Best regards,
Lionel Chen

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