Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Hi, I have tried USERNAME () which is returning domain\userID in Desktop and in web it is returning emailID. I want to see Firstname and Lastname of user as in AD. is there any way that I can show Lastname,Firstname in dashboard.
Hi @Kcponakala ,
If you want to import data from AD, you could refer to this blog to load user table into Desktop.
Hi,
create a disconnected table which holds the Fullname (Firstname & Lastname) and the USERPRICIPALNAME. Use a measure like this:
User = CALCULATE(VALUES(DisconnectedTable[Name]), DisconnectedTable[Userprincipalname] = USERPRINCIPALNAME())
Use this measure in a card visual.
Regards FrankAT
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the September 2025 Power BI update to learn about new features.