Forum Discussion

W33628's avatar
W33628
Frequent Visitor
7 years ago

RLS based on multiple columns

I have a mapping table that maps Users  to the IDs that they have access to in my report. I then join this table to my main table in Power BI and then set up a role for my Row Level Security. This wo...
Need Help
TeigeGao's avatar
TeigeGao
Solution Sage
7 years ago

Hi W33628 ,

In your scenario, we cna use lookupvalue function to get ID from the first table, then use or function to filter the data.

Best Regards,

Teige

SathyaG35's avatar
SathyaG35
Frequent Visitor
6 years ago

Hi, 

 

I noticed you posted this answer can you please post any example code on how to handle it?