Forum Discussion
Solved
Security parameter
Hello guys, I'm starting in Power BI (desktop) and would like to help. I saw that we could create security levels through groups and allocate users to these groups. But I would like to defi...
- LRFeltz
As mentioned you can make use of Username() function of dad to be able to do this. However make sure in your user table you have email address of a user as username() in power bi desktop will return domain\username while in power bi service it will return email address of logged in user.
i use a table called region myself for this. two solutions:
1. use the RSL in service version (click elipsis on dataset then security). This is super easy but the RSL is still beta and will be overridden on data refresh.
2. use DAX function username() as a filter. This works if your table contains all your users ID's assigned to the correct regionalities. Then just join region[reagion_name] to fact[region_name] (or whatever it might be).