Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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!