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.
Im creating a dashboard for detailed insights in meeting analytics using Outlook calender. As of now I have done dashboard which asks user to put email id as input parameter but instead of this I would like PowerBI to select/detect/capture email id automatically from UPN. So once user open power bi template, he/she should be able to see insights directly without even putting email ID.
@Anonymous there is dax function called userprinciaplname, may be that can help
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Hi Parry2k,
Thanks for replying. I want user principal name as a source in querry. I created parameter which asks for a input to user,so user email id becomes source in querry.
- So I want userprincipal name as source.
-This is for the purpose of getting meeting insights only for people who are working in our company.
- I short, I dont want user to put his email id as a data source, instead I want power bi to detect userprincipalname and extract data accordingly.
@Anonymous the way i see it working is that you pull all the data with email in it and then you add a column in you model something like this
Current User = Table[Email] = USERPRINCIPALNAME()
and now you put a report level filter with "current user = true"
And other solution could be Dynamic RLS.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@parry2k It seems it creates table out of the power querry but instead I want to do it in the power querry.
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 |
---|---|
117 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |