role level security question

[River]

Hi Friends,

I have lots of users to access report, when I setup role level security, I have to, for eaxmple, set to different "country" for users to access.

But, for a few users, they should see all countries, how do I create a role for it? is there something in DAX like *.*?

Many thanks!

[Greg_Deckler · Accepted solution]

Well, you could create a role with a filter expression of:

TRUE()

And it is row level security. https://docs.microsoft.com/en-us/power-bi/desktop-rls

[V-lianl-msft]

Hi @River ,

You can refer to this for more information:https://key2consulting.com/how-to-setup-row-level-security-rls-in-microsoft-power-bi/ 

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

[Greg_Deckler · Accepted solution]

Another way, an RLS rule of:

[Country] <> "this is garbage text that will never be a country name"

[Greg_Deckler · Accepted solution]

Well, you could create a role with a filter expression of:

TRUE()

And it is row level security. https://docs.microsoft.com/en-us/power-bi/desktop-rls