Need help in DAX Expression for RLS Direct query

[rsathish_red]

I have 5 related tables. I have to block users by role

If i enable the 'import' mode below expression is working but not in Direct query mode. Is there any method to convert it so i can use it in direct query mode?

[id] IN SELECTCOLUMNS (
FILTER (
    'user_project',
    (RELATED('users'[id]) = VALUE(USERNAME()) && 
    RELATED('roles_groups'[name]) <> "Power User")
   ),  "projects", [project_id]
)

[v-yulgu-msft]

Hi @rsathish_red,

SELECTEDCOLUMNS() is not a supported function in Direct Query connection mode.

Best regards,

Yuliana Gu

[rsathish_red]

How should i rewrite the query to work in DirectQuery?

[PBIEhand]

Did you find a solution?