RLS in power bi service is not working with 'IN'

[brunozanoelo]

Hello, I'm having serious problems sending my file with RLS to the power BI service.

It happens that, my access rule in DESKTOP seems to work, but on the site the rule does NOT work !!!

My rule is this one...  Is correct!?? Can i use "IN" on the RLS? In Desktop Works!!

([Código Agente de Vendas] IN (27,38,44,45,48,55,60,63,86,96,102,126,143,175,184,185,197,213,215,227,262,298,325,522,544,907))

Please!!!

[brunozanoelo · Accepted solution]

Hi @KHorseman, i changed "in" to "=", to use in another field.

idk if "in" works correctly, because in desktop works and in the service not. This is strange.

Many thanks

[KHorseman]

Try placing the list of conditions in {curly brackets} instead of (parentheses). I haven't tested this but that seems to be the way Power BI Desktop generates IN statements according to the bottom of this article.

([Código Agente de Vendas] IN {27,38,44,45,48,55,60,63,86,96,102,126,143,175,184,185,197,213,215,227,262,298,325,522,544,907})