RLS based on a Column

[ErickReiis]

RLS based on a column Hello everyone, how are you? I need your help to create an RLS rule that indicates the contents of a specific column to apply a rule. For example, in a department we have Directors, Superintendents as in the example below:

Is there a way to apply a request rule to look at a specific column instead of the entire row? For example, as much as there are people in the C frame, there are people who can only see CP while others see C. I want exactly that portion that will check only the CP

[v-henryk-mstf · Accepted solution]

Hi @ErickReiis ,

The full name of RLS is row level security, so filters restrict access to data at the row level. They cannot be configured to restrict access to model objects (including tables, columns or metrics).

For more details, you can read below document:

Row-level security (RLS) guidance in Power BI Desktop - Power BI | Microsoft Learn

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.