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.
Hello,
I just started learning Power BI and I bumped into this problem regarding Row Level Security using advance DAX. I have this Table filter DAX expression [Email] = UserprincipalName but it turned out that all of the data in the column I am referring to had a fix suffix (e.g. @mydomain.com) but some of the user audience I want to share the report to authenticates with only @domain.com suffix. I tried creating another column [AlternateEmail] and used SUBSTITUTE function to replace @mydomain.com to @domain.com and set the Table filter DAX expression to [Email] = UserprincipalName() || [AlternateEmail] = UserPrincipalName() but did not work. Can you do advance DAX on the Table filter DAX expression using userprincipalname() function that accepts both?
Thank you in advance
Hi Icey,
Thank you for your response. I appreciate the video and I have done this. It turned out that the audience I want to share it to has multiple domains as there were a lot of branches globally not only @domain.com and @mydomain.com. I am guessing we acquired a bad mapping data, so my approach is a sort of like dynamic filtering on the columns we are using. Is it possible to apply this on the table filter DAX expression?
Hi @alexanderandro ,
Sorry, I'm confused. Isn’t the result returned by your formula always "TRUE"?
Best regards
Icey
If this post helps, then consider Accepting it as the solution to help other members find it faster.
Hi @alexanderandro ,
I have this Table filter DAX expression [Email] = UserprincipalName but it turned out that all of the data in the column
How did you test it? Did you both select "Others" and your new role like below?
Best regards
Icey
If this post helps, then consider Accepting it as the solution to help other members find it faster.
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.
User | Count |
---|---|
112 | |
96 | |
78 | |
68 | |
55 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |