RLS with multiple combination

[Kharansu_KR33]

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 ID	Hierarchy	Country	Zone	State	Locations	Punching Machine
dinesh.g@xyz	Country Head	India	All	All	All	All
bhavesh.s@xyz	Zonal Head	India	East	All	All	All
sumedh.lakha@xyz	Zonal Head	India	West	All	All	All
asish.fn@xyz	Zonal Head	India	South	All	All	All
simran.kaur@xyz	Zonal Head	India	North	All	All	All
ramnujan.g@xyz	Country Head	Srilanka	All	All	All	All
mutthu.pillai@xyz	Zonal Head	Srilanka	East	All	All	All
hariharan.s@xyz	Zonal Head	Srilanka	West	All	All	All
dinesh.lamba@xyz	Zonal Head	Srilanka	South	All	All	All
dinesh.gopi@xyz	Zonal Head	Srilanka	North	All	All	All
paramesh.rr@xyz	Area Business Head	India	East	Odisha	All	All
rohit.bhatt@xyz	Area Business Head	India	East	Bihar	All	All
kriti.s@xyz	Area Business Head	India	East	Chhattisgarh	All	All
swati.m@xyz	Area Business Head	India	West	Maharashtra	All	All
jignesh.p@xyz	Area Business Head	India	West	Gujrat	All	All
mariam.d@xyz	Area Business Head	India	West	Goa	All	All
krishna.m@xyz	Manager	India	East	Odisha	Kalahandi	P1
krishna.m@xyz	Manager	India	East	Odisha	Cuttack	P2
ramesh.s@xyz	Manager	India	East	Odisha	Cuttack	P1
ramesh.s@xyz	Manager	India	East	Odisha	Kalahandi	P2

[ibarrau]

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,

[Kharansu_KR33]

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

[ibarrau]

Hi. You can check the pbix of the example at my github repo: https://github.com/ibarrau/PowerBi-code/blob/master/PowerBi%20Reports/BlogDemos.pbix

Remember you can test how the role looks like with specific email and rule selected at PBI Desktop.

Regards,

[Kharansu_KR33]

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?

[ibarrau]

Well that's the dax challenge I have mentioned before. You will need to think about a logic asking for the columns and don't filter when "All" or something like that.

Yes, you also have the option of separating a row for each combination without the all. That would make DAX easier because you could build a column for each table (RLS table and dimension) that matches exactly for the rows to filter.

I hope that make sense