Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
89 | |
87 | |
82 | |
64 | |
49 |
User | Count |
---|---|
124 | |
110 | |
88 | |
68 | |
66 |