RLS to hide specific customers

[tracytran91]

Hi friends, 

I have a list of customers need to hide for specific position. 

How could I make it in RLS dynamically? 

Any help is highly appreciated. 

[Anonymous · Accepted solution]

Hi @tracytran91,

You can set dynamic RLS based on username and add conditions to compare and exclude users stored in the particular tables.

Solved: RLS with UserName() - Microsoft Power BI Community

Regards,

Xiaoxin Sheng