Row Level Security for multiple values in a column

[prasanthd]

Hi Everyone,

I have a scenario where there are multiple values in SITE column.

If the values in SITE column are single like ACH, LYP etc.. then data is showing up when using RLS.

In the below Screenshot for the value in EMAILADDRESS is Jona.int@test.com, the value in SITE is API,MAS. Here when using RLS, SITE value is not showing in the report.

Appreciate your response.

Thanks,

Prasanth.

[prasanthd]

Thanks for the response @MFelix , I have already tried doing it and its successfull, but my requirement is to get API, MAS as one single site.

Thanks.

[MFelix]

Hi @prasanthd ,

When you mean to get the API, MAS has a single site what do you mean? RLS is just the an access to the information if your user has access to both the sites then the calculations will get properly done, the fact that you split the sites on the RLS configuration will not only give you one of the sites, it will return the result for all the sites the user has acess.

[Thejeswar]

Hi @prasanthd ,

Split the Site Column into multiple rows and then apply your RLS as the RLS works with only perfect matches

Refer the below link if you want to know how you can splot the column values to multiple rows

https://community.fabric.microsoft.com/t5/Desktop/Split-comma-delimited-cell-into-multiple-rows-keep...

Regards,

[MFelix]

Hi @prasanthd ,

Is the API, MAS one single site or two? If this is a value for more tha one site I recommend that you split this into a row for each of the site so in this case Jona would have two rows one for API and anothe for MAS that should return the values you need.