Forum Discussion

vanessafvg's avatar
vanessafvg
Community Champion
9 years ago
Solved

RLS for individuals

I need to create a model that has a variety of agents accessing it -  each should only see there own data - to set them up using row level security do I create a role for each user, and then add the ...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    vanessafvg It sounds like you want to use Dynamic RLS. This method allows you to use a dynamic way to filter data within the model. Really high level, it requires you to build a mapping table with the user info and what they will be filtered by. Here are a couple links that will get you headed in the right direction, but essentially this method calls for 1 role, and DAX is used to recognize the user and filter the model accordingly.

    This example is for a full tabular model build, but is relevant to the Desktop

    And this example by Reza Rad show a simple implementation using the Desktop

     

    and a final tips portion from GilbertQ can be found here

Anonymous's avatar
Anonymous
Not applicable
9 years ago

vanessafvg It sounds like you want to use Dynamic RLS. This method allows you to use a dynamic way to filter data within the model. Really high level, it requires you to build a mapping table with the user info and what they will be filtered by. Here are a couple links that will get you headed in the right direction, but essentially this method calls for 1 role, and DAX is used to recognize the user and filter the model accordingly.

This example is for a full tabular model build, but is relevant to the Desktop

And this example by Reza Rad show a simple implementation using the Desktop

 

and a final tips portion from GilbertQ can be found here

catalind86's avatar
catalind86
Frequent Visitor
8 years ago

Thank you Anonymous

Can you please let us know if we can implement Dynamic RLS for On-premises Power BI Report Service?

Thank you in advance.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    catalind86 Yes, RLS will work in PBI Report Server