What the heck is USERPRINCIPALNAME in Power BI? (Row-Level Security)

Ever wonder what USERPRINCIPALNAME is in DAX within Power BI? Or the difference between USERPRINCIPALNAME and USERNAME? Hint - It's used with Row-Level Security.

*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.

*******************
LET'S CONNECT!
*******************

***Gear***

#PowerBI #2M2 #GuyInACube

[leoespejo]

Both Patrick and Andam are the real heroes here, you always save the day

[leonardomauro]

Always nice to refresh the DAX functions!

[michaelheard]

I have been using this on a project this week which links to Users via many organisations to filter permissions on what datasets users can see. That was a challenge! Project for schools.

[hotboyphil]

appricaite these mini videos that ansewer a question i was dealing with while trying to follow your power bi roe level secruit and where to filter video.

[supriyavaradan]

Hi i am working in other visualization tools sap bo. In order to display last weekend = RelativeDate(Current Date() How to use the same formula in dax

[isalys]

Thank you for the video :) I need help because I can't publish to web my power bi report. I don't have tenants settings in my admin portal. What can I do?
I found that the solution is to create an admin for my domain name server but I don't own the DNS. So what can I do?

[myrandomandboringvideos]

Hey Patrick & Adam, Could you make a video on explaining the columns in Vertipaq of Power BI data model. Thanks in advance

[ssyed]

Hi there, how do we handle RLS when the email addresses are being re-used between an Inactive employee who left the company a while ago and an existing employee that has the same email address as the Inactive employee. Our Org has the policy to re-use email addresses if the AD account is inactive for a period of time. Any thoughts? Its causing issues especially with filtering based on Dynamics 365 data

[rahulkallur]

does userprincipalname() fetch emailid when user logins other than microsoft portal?

[rohitkarnatakapu]

What if the table contains guyinacube\asaxton instead of email id? Is there any DAX function which returns the alias in both desktop and service?

[AliHasan-lrxj]

Hi, based on username can we or how can we set a rules say to view some visuals on our report to specific users and not to all users ?

[arklur]

I would mention that the same is true in the PBIRS, not just the service.

[JoshuaTalley]

Been using RLS for a couple of years now. My model is a bit complicated, and it would be nice to apply different levels to specific pages...😉

I am having an issue with a particular report page and some related visuals. I've talked with support about it before, but now the issue is back. They thought it had to do with RLS. Going to check out there course!

[googol]

Tried this in Power BI Desktop (v. June2020) - and both Username() and UserPrincipalName() return the local domain credentials. Thoughts?