Syntax error when using RLS

[Anonymous]

Hi

I'm trying to implement Row Level Security, using as a example the radacad tutorial (https://radacad.com/dynamic-row-level-security-with-manager-level-access-in-power-bi)

I've adapted it to my tables, and If I create a measure with the code, it works.

But when I try to add it to the RLS tab, I  get an error: "The syntax for ";" is incorrect"...

Can anybody help me with this error?

BTW: For some unknown reason, in my computer, all expressions works with ";", but in my collegues computers, the expressions works with ",".

Thanks!

If( 
    MaxX(
        Filter(
        'RLS_Test_Data';
        'RLS_Test_Data'[EMAIL_USER_RLS]=USERPRINCIPALNAME()
        )
        ;'RLS_Test_Data'[IS ADMIN]
    )=0;
    FIRSTNONBLANK(RLS_Test_Data[EMAIL_USER_RLS];RLS_Test_Data[EMAIL_USER_RLS])=USERPRINCIPALNAME();
    1=1
)

[v-yuta-msft]

@Anonymous ,

This issue should be related to the region settings. Please update power bi desktop to the latest version and check if this issue persists.

Regards,

Jimmy Tao

[Anonymous]

I've updated to the last version  2.78.5740.861 and the error is still there.

[Anonymous]

I've tryied changing all the ";" to , and it worked. Have no idea why, but seems to be a bug of PowerBi, because in a measure it need to be with ";" and in RLS with ","

[Greg_Deckler · Accepted solution]

Interesting, that's usually a regional language setting things. You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it. It does kind of sound like a bug.