Forum Discussion

La_Panic's avatar
La_Panic
New Member
6 years ago

RLS multiple combination with different levels

Hi there,

I would like to implement Dynamic RLS in Power BI adapting Corporate Heirarchy logic to Region Hierarchy.

I have 4 Levels listed folowing:

Country, East/west, State, Store

I have to manage different exceptions so you can notice that the user a@Group have access to two different levels means Level 2 East ( all the stores belonging to East region) also Store O1 this store is from the west Region.

 

Thanks for your help

My Tables

Need Help

2 Replies

  • kentyler's avatar
    kentyler
    Solution Sage
    6 years ago

    Since your access levels cross over regions, I think the way forward will be easier if you multiply your store/sales combinations with the regions, so you have an access level id for each store/sale/region combination.
    This is an interesting problem. I'd be happy to do a screen share and talk more about it. If you want, send me your email and a good time to talk. [email protected]

     

     

    Power BI is easy to learn, but it has hard parts.
    I'm a personal Power Bi Trainer I learn something every time I answer a question
    How to Get Your Question Answered Quickly 

     

    • La_Panic's avatar
      La_Panic
      New Member
      6 years ago

      Thanks kentyler,

      I thought about this solustion but I have a constraint that could affect the performance:

      1000 store * 4 levels also more than 700 users + many many exceptions ...

      le me know if you think that this could be managed with your solution and the performance will be good ?

      How to link my tables ?

      Regards