Row Level security Formula

Question

Row Level security Formula

RAVISHANKAR R (DHL IT Services) 6

Hi ,

I am trying to achieve a row level security filter through analysis services tabular model using Lookupvalue function based on the two columns in a security table , where based value in either of one column the RLS should work,

'User'[Country]
= LOOKUPVALUE (
'Users'[Country],
'Users'[email], USERPRINCIPALNAME (),
'Users'[Country], 'FACT_TABLE'[Country]
)
&& 'User'[Region]
= LOOKUPVALUE (
'Users'[Region],
'Users'[email], USERPRINCIPALNAME (),
'Users'[Region], 'FACT_TABLE'[Region]
)

The filter need to check the value from both the columns. here would like to know whether (AND (&&)) operator will work in RLS or not.
Thanks.

ShaikMaheer-MSFT 38,556 Reputation points Microsoft Employee Moderator

2021-07-27T07:07:28.47+00:00

Hi @RAVISHANKAR R (DHL IT Services) ,

Following up to check is below answer provided by @CarrinWu-MSFT helped you? If yes, Please Accept Answer. Accepting answer will help community too. Thank you. Please feel free to ask if any further queries.
ShaikMaheer-MSFT 38,556 Reputation points Microsoft Employee Moderator

2021-07-30T05:47:04.103+00:00

Hi @RAVISHANKAR R (DHL IT Services) ,

Just checking is below answer provided by @CarrinWu-MSFT helped you? If yes, Please Accept Answer. Accepting answer will help community too. Thank you. Please feel free to ask if any further queries.

1 answer

Your answer

ShaikMaheer-MSFT 38,556 Reputation points Microsoft Employee Moderator

2021-07-27T07:07:28.47+00:00

Hi @RAVISHANKAR R (DHL IT Services) ,

Following up to check is below answer provided by @CarrinWu-MSFT helped you? If yes, Please Accept Answer. Accepting answer will help community too. Thank you. Please feel free to ask if any further queries.
ShaikMaheer-MSFT 38,556 Reputation points Microsoft Employee Moderator

2021-07-30T05:47:04.103+00:00

Hi @RAVISHANKAR R (DHL IT Services) ,

Just checking is below answer provided by @CarrinWu-MSFT helped you? If yes, Please Accept Answer. Accepting answer will help community too. Thank you. Please feel free to ask if any further queries.

Answer 1

CarrinWu-MSFT 6,891

Hi @RAVISHANKAR R (DHL IT Services) ,

Welcome to Microsoft Q&A!

here would like to know whether (AND (&&)) operator will work in RLS or not.

As my research, it works. Please refer to Logical operators to get more information.

Best regards,
Carrin

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Share via

Row Level security Formula

1 answer

Your answer