- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 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 |
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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,
Happy to help!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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,
Happy to help!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Happy to help!

Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
Anonymous
| 05-18-2019 04:54 AM | ||
12-27-2024 02:55 PM | |||
10-15-2024 02:10 PM | |||
10-18-2024 12:35 AM | |||
01-15-2025 08:57 AM |
User | Count |
---|---|
49 | |
33 | |
32 | |
27 | |
24 |
User | Count |
---|---|
40 | |
33 | |
19 | |
18 | |
16 |