Forum Discussion
Get username in Power Query
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
3 Replies
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.
