Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi community
The following post describes 4 ways to get the username in Power Query :
https://querypower.com/2017/04/03/4-ways-to-get-username-in-power-query/
Unfortunately, the simplest method (n°2) is not reliable because of NTFS delay as explained in the post.
So I developped a function using the same concept with some improvements :
https://thebipower.fr/index.php/2020/03/04/get-username-function-in-power-query/
Hoping it helps
Solved! Go to Solution.
Hi @DidierTerrien ,
Thanks for sharing that!
Hi @DidierTerrien, really sorry to pop up to this thread so long after your comments, but I would like to know whether your proposal could be applied, with some improvements, to a report published on Power BI Server, or if it is only available for Power BI Desktop (I'm assuming it since it search for a local folder in C:\\.
Thanks,
Damiano
See my reply above. C Drive path did not work when published. (Unless I missed something) The Web connection to SharePoint did, using oauth2 on the gateway --it always returns the person running the report at the time.
Hi @DidierTerrien ,
Thanks for sharing that!
User | Count |
---|---|
20 | |
10 | |
10 | |
9 | |
7 |