RLS - assign all other users a role, without defining username

[Anonymous]

Hi all,

I have tried to get a solution to my problem with the help of row level security but I'm stuck. 

I would like to assign one or maybe two persons who should have access to all the data in a report. Then I would like to assign ALL the other users to not have access to all the data, i.e. I would like to have an automatic solution to not have to specify all the other users username.

Do you know if it is possible to assign all other users who is not defined as a certain role? 

Would be so glad if I could get som help with this question!! 

[amitchandak]

@Anonymous , see if this can help

https://www.youtube.com/watch?v=oxYQ2GGefrs

[Anonymous]

With this solution you still have to define every user and their username/email in a table in Power BI for those who should be in the group. Whitch is what i want to avoid.