RLS

[Anonymous]

Hi, Is there a way to add more restrictions to an existing RLS?

For example, if there's a COST 1 and a COST 2 in one table and multiple roles can each role see one or the other?

[Anonymous]

Hi @Anonymous ,

First of all, you have to have editing rights for the report. What each role can see depends on your rules.

Here's the example you can refer to.

There are other links about RLS at the end of this article for you to learn. They're very helpful.

Best Regards,

Stephen Tao

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

[Fowmy]

@Anonymous 

You can add multiple values as follows in RLS formula

[Columnname] IN {"Item1", "Item2"}

[Greg_Deckler]

@Anonymous RLS does not cover column level security. For that, you will need to use the CLS pattern or OLS in Tabular Editor.

Column Level Security in Power BI - Microsoft Power BI Community