RLS based on multiple columns

[W33628]

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 works great.

But now I need the security based on the possiblity of that ID in multiple columns on each row. For example if any of the 3 ID fields is 567, the person with access to that ID can see all of those rows. So basically it needs to be if ID=567 or ID2=567 or ID3=567. However, in Power BI I can only join my mapping table on 1 column. Is there a way to do this?

Example of Mapping Table

User                        ID

bob@gmail.com	567
me@gmail.com	789

Example of Data Table

Sales     ID     ID2   ID3

50		567	789
100	567
1000	789	567

[SathyaG35]

I am having the same trouble. Any solutions on this?

[TeigeGao]

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]

Hi, 

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

[W33628]

@TeigeGao 

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

[ncbshiva]

Hi All,

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

Regards,

Shiva