Forum Discussion
role level security question
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!
- 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 Another way, an RLS rule of:
[Country] <> "this is garbage text that will never be a country name"
3 Replies
- 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 Another way, an RLS rule of:
[Country] <> "this is garbage text that will never be a country name"
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.
