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 relati...
Data Protection
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

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Hi. Thanks a lot. But how does Power BI read "All" for a column value and show all the related values for a particular hierarchy and not all the values that the column holds?

        Do we need to create a separate column that's the combination of the columns present for a specific row?