Get username in Power Query

[DidierTerrien]

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

[Anonymous]

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

[scottostanek]

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.

[v-frfei-msft · Accepted solution]

Hi @DidierTerrien ,

Thanks for sharing that!