DAX Help: RLS using IN CUSTOMDATA() and JSON-list

[Anonymous]

Hi! Need your help with DAX troubleshooting. Right now, I am clueless.

So, in Analysis Services I have used the Additonal Connection Parameters to add CUSTOMDATA(), where I want to pass a JSON list of values.

This does not work, and I get the following error:

A table expression for the argument was expected, but a string or numeric expression was used

When I try to troubleshoot this and work around it; i use the following with no issues at all - this works fine.

EVALUATE
FILTER
       ('v_pact_d_reseller_customer',
              'v_pact_d_reseller_customer'[Id] IN {20087,20088,20089}
       )

But when I try this, it does not work. 

EVALUATE
FILTER
       ('v_pact_d_reseller_customer',
              'v_pact_d_reseller_customer'[Id] IN CUSTOMDATA()
       )

From my perspective, they should return the same values. What am I doing wrong? 

Thanks!

[v-yulgu-msft]

Hi @Anonymous ,

As stated in this article, the CustomData feature only works for models that lie in Azure Analysis Services, and it only works in Connect live mode. Unlike users and roles, the Custom data feature can't be set inside a .pbix file.

Best regards,

Yuliana Gu

[Anonymous]

Hi @v-yulgu-msft, and thanks for your answer.  I am using Azure AS and Live Connection - sorry for not mentioning that. As you can see from the screenshot, I am trying to set it in SQL Server Management Studio.

[Anonymous]

Any solution in sight ? I'm strugeling with this as well