Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Dynamic row level security

Hi guys,    When designing my model i believed my use case would be very simple, quite the opposite.  The following picture is a representation of my model: It has 1 fact table surrounded by 13 ...
Need Help
v-xicai's avatar
v-xicai
Community Support
7 years ago

Hi Anonymous ,

 

Please see the link Power BI Desktop Dynamic security cheat sheet, which described the detailed steps. Maybe it doesn't work, there are some tips to let it work and test it efficiently.

 

You can also refer to the similar case: https://community.powerbi.com/t5/Desktop/Dynamic-RLS-role-creation-based-on-Login-name/td-p/397734.

 

Best Regards,

Amy

 

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hey,

     

    Thanks for the the tips but my use case is slightly different and I've read most of those.

    They're only filtering from let's say a RLS table to a region dimension to a fact.

    All my 10 + dimensions have to be filtered too and I'm looking for an efficient way to 'propagate' my filter from my fact to my other dimensions. 

    Currently I can do this through using a custom visual that forces the user to select a slicer element, then my RLS is properly propagated.

    I'm looking for alternatives to this.

    • v-xicai's avatar
      v-xicai
      Community Support
      7 years ago

      Hi Anonymous ,

       

      For all the relationships, try to change the Cross filter direction from Single to Both, which will take them treated as a single table, and will take the 'propagate' effective.

       

      Best Regards,

      Amy

    • v-xicai's avatar
      v-xicai
      Community Support
      7 years ago

      Hi  Anonymous ,

       

      Does that make sense? If so, kindly mark my answer as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

       

      Best regards

      Amy

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Hey, 

         

        Thanks for trying but that didn't work for me. My use case is rather annoying as I don't only need to filter my fact table, I need to filter EVERY dimension because they all have rather sensitive information. 

         

        As of today I have two bad solutions which are adding a bridge + security table onto each dimension that needs to be filtered in addition to my fact.

         

        Create a view that combines my fact tables with my security table.