Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi every body! I need a help, because I don't know of is possible or madness.
In the company I work for, we have a Power BI that serves as a query for our sellers, where they can view their orders.
And we want the first dashboard to have a greeting, like "Hello, 'here will have the name of de user who is logged in to Power BI online'".
Is that possible? And how can I do it?
I have tried using the formulas USERNAME, USEROBJETID and USERPRINCIPALNAME, but just brings me the user's email or a code, I would like the name to appear.
Hi @AnaCordeiro ,
I find a topic and change it to satisfy your requirements: Solved: How to display Username with greetings when user ... - Microsoft Fabric Community
I create a table as you mentioned.
Then I create a calculated column and get what you want.
Greeting =
VAR user =
USERNAME ()
VAR greeting1 = "Hello, 'here will"
VAR greeting2 = "is logged in to Power BI online'"
RETURN
greeting1 & " " & user & " " & greeting2
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
You can use either USERPRINCIPALNAME or USERNAME to get the user's login name, you just need to either extract text before '@' delimiter for USERPRINCIPALNAME, or after the domain name '/' for USERNAME.
So you want to tell them what their own name is?
User | Count |
---|---|
97 | |
87 | |
76 | |
67 | |
63 |
User | Count |
---|---|
112 | |
96 | |
95 | |
67 | |
65 |