question

RAVISHANKARRDHLITServices-5573 avatar image
0 Votes"
RAVISHANKARRDHLITServices-5573 asked ShaikMaheer-MSFT commented

Row Level security Formula

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.


sql-server-analysis-servicesazure-analysis-services
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @RAVISHANKARRDHLITServices-5573 ,

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.

0 Votes 0 ·

Hi @RAVISHANKARRDHLITServices-5573 ,

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.

0 Votes 0 ·

1 Answer

CarrinWu-MSFT avatar image
0 Votes"
CarrinWu-MSFT answered

Hi @RAVISHANKARRDHLITServices-5573,

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.
117788-file.png


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.



file.png (30.1 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.