How does CUSTOMDATA() function work in Dynamic Row Level security on Azure Analysis Services

Question

Hello,

I am try to use my Dynamic Row level security filter formula as below on a SSAS tabular model.

=’Sales Territory'[Sales Territory Country]
= LOOKUPVALUE(‘Security Bridge Country'[Country],
‘Security Bridge Country'[Country], ‘Sales Territory'[Sales Territory Country],
‘Security Bridge Country'[UserName], ****CUSTOMDATA()****
)

When I try to use this CustomData() as a measure value it display as BLANK value ? In this case I need to use it for my RLS. Please suggest me how to use it.

Answer 1

@RAVISHANKAR R (DHL IT Services) ,

Thanks for using Microsoft Q&A !!
I suspect you have not defined the customdata property at the connection time and thus you are getting blanks. Are you trying use this AAS model with PowerBI embedded. If so, please refer to the documentation section - embedded-row-level-security for additional details. Additional document to refer is here.
Also could you please elaborate on your use case if this is not the case ?

Thanks
Saurabh