Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi!
I've created a RLS in PowerBI using the DAX userprincipalname().
It works fine for the individual email adresses (makes me think that the tables and connections are ok) but when using distribution lists, the users cannot see any info. Their emails are in the DL that I uploaded. The DL is also in the Security tab and RLS tab.
This is an example of the users mapping table format I am using at the moment.
The filter corresponds to a role (connected to other table).
The DAX formula I am using is the following too.
Why does this happen? Thank you a lot.
Solved! Go to Solution.
Hi , @ACCR
System cannot identify user name . According to the offical document you can see that when you use username() or userprincipalname() , usually returns a user in the format of DOMAIN\User or a user in the format of user@contoso.com. When you enter the user's name, it can only determine that this is a text column, but not a user name column.
Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi , @ACCR
System cannot identify user name . According to the offical document you can see that when you use username() or userprincipalname() , usually returns a user in the format of DOMAIN\User or a user in the format of user@contoso.com. When you enter the user's name, it can only determine that this is a text column, but not a user name column.
Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Yes! Thank you a lot.
Is there any workaround for the DL's to be accepted?
Hi , @ACCR
Can you describr your operation in detail ? From the DAX you provided , there is no problem . Did you test RLS in Desktop ? Can RLS work ? Did you create relationship between User table and data table ? You can refer to the offical document to check your configuration .
https://docs.microsoft.com/en-us/power-bi/enterprise/service-admin-rls
Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi! Thank you so much for the answer!
I am sorry I didn't give musch details.
Did you test RLS in Desktop ? - Yes
Did you create relationship between User table and data table ? Yes, the mapping is done correctly!
The only thing that I am seeing is that the system do not recognize the user using Distribution Lists. Only if I write the users email individually, the RLS works.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.