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

  • W33628's avatar
    W33628
    Frequent Visitor
    7 years ago

    TeigeGao 

     

    Where would I put that function? Would it be built into the Role I have defined? Can you provide an example?

    • ncbshiva's avatar
      ncbshiva
      Advocate V
      5 years ago

      Hi All,

       

      I also need solution for this. Can anyone help us ?

       

      Regards,

      Shiva

  • 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?