Forum Discussion
How to by default restricted access by Row Level Security
Hi ckwongak ,
For roles that are not assigned, he will not see any data. You can test with a user who is not in the user list. Below is the tutorial.
Validate the roles within Power BI Desktop
If you want to some of the user to able to see multiple country data, it's possible and you need to connect information from multiple countries with users.
For dynamic RLS, here're some helpful blogs for your reference.
Row-level security (RLS) with Power BI - Power BI | Microsoft Learn
Dynamic Row Level Security with Power BI Made Simple - RADACAD
Dynamic Row Level Security with Manager Level Access in Power BI - RADACAD
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.
Hello ckwongak ,
Yes if the user us not assigned to a role, then there would be no filtering for him to see specific things.
Regarding the user seeing many countries, you should assign the countries to him.
check this documentation from microsoft for more details on RLS https://learn.microsoft.com/en-us/power-bi/enterprise/service-admin-rls
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Yes, but I would like to look for the vice versa, if the user is not on the list, he will see nothing. How to do this in Power BI?