I want to be able to assign all users (including new ones) to a default role in RLS. Currently I have to assign each user to the role manually, and update the roles manually when users change. This ...
Internal users roles can easily be managed by O365 groups. role called 'Department' - single member in PowerBI: [email protected] managing actual users to be members of [email protected] distribution group will propagate to powerBI just fine. [email protected] is member of [email protected] group - I am automatically member of 'Department' role (and see data based on this role DAX filtering) If you are to grant read only access to anyone outside of the company - user is not part of "@company.com" he/she will not match anything in local groups. Solution would be to allow wildcards as members of custom role: lets say custom role named "Everyone" - with one member: * - effectively matching everyone. With this setup, role named 'None' as visible in PowerBI Desktop will have no members (every user is forced to be member of "Everyone" role - unless matching filter for other roles) Another option would be to allow DAX filtering on 'None' role (currently not possible).
