Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

RLS with multiple combination

Hi all,

I have provided a table here for some combinations of securities that should be applied to my dashboard. How to achieve it?

1. Can I directly import this table to my model and create relation with my existing tabel?

2. Can the exact combinations be allowed, so that the respective e-mail ids can interact with all or provided combinations?

 

Thanks in advance.

E-mail IDHierarchyCountryZoneStateLocationsPunching Machine
dinesh.g@xyzCountry HeadIndiaAllAllAllAll
bhavesh.s@xyzZonal HeadIndiaEastAllAllAll
sumedh.lakha@xyzZonal HeadIndiaWestAllAllAll
asish.fn@xyzZonal HeadIndiaSouthAllAllAll
simran.kaur@xyzZonal HeadIndiaNorthAllAllAll
ramnujan.g@xyzCountry HeadSrilankaAllAllAllAll
mutthu.pillai@xyzZonal HeadSrilankaEastAllAllAll
hariharan.s@xyzZonal HeadSrilankaWestAllAllAll
dinesh.lamba@xyzZonal HeadSrilankaSouthAllAllAll
dinesh.gopi@xyzZonal HeadSrilankaNorthAllAllAll
paramesh.rr@xyzArea Business HeadIndiaEastOdishaAllAll
rohit.bhatt@xyzArea Business HeadIndiaEastBiharAllAll
kriti.s@xyzArea Business HeadIndiaEastChhattisgarhAllAll
swati.m@xyzArea Business HeadIndiaWestMaharashtraAllAll
jignesh.p@xyzArea Business HeadIndiaWestGujratAllAll
mariam.d@xyzArea Business HeadIndiaWestGoaAllAll
krishna.m@xyzManagerIndiaEastOdishaKalahandiP1
krishna.m@xyzManagerIndiaEastOdishaCuttackP2
ramesh.s@xyzManagerIndiaEastOdishaCuttackP1
ramesh.s@xyzManagerIndiaEastOdishaKalahandiP2
Data Protection

5 Replies

  • ibarrau's avatar
    ibarrau
    Super User
    3 years ago

    Hi. Yes. You can import the table in order to relate that with the dimension that contains the conditions like something related with country/location. The table might be * to *. I know they say you shouldn't ever do that, but the real answer is "be aware of what you are doing before using that".

    You can use a single direction from the rls to the model in order to create a dynamic filter. The more columns you want to use for conditions the more complex the rules of dax will be. Usually when it's one, with a simple usernameprincipal() it's enough, but if you want to compare also a smaller granularity, you might need to build a complex dax inside the dimension besides the rule for the RLS table.

    You can check this simple example to get the idea step by step.

    https://blog.ladataweb.com.ar/post/652895563673649152/powerbi-seguridad-de-filas-rls-con-regla

    I hope that helps,

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi ibarrau,

      Thank you for responding and clarifying the concept. Just a request, to check the application of the particular RLS; if I create a pbix file and attach it here, can you attach a working version of rls dashboard here?

       

      Thanks in advance