Power Query

Get username function in Power Query

Get username function in Power Query with few lines of M code. For the moment, there is no native way to get the Windows username in M language. The username might be useful to filter a table or to get a file path in the ‘Documents’ folder. The following post describes 4 ways to get…

Power Query

M functions documentation within Power Query

Often we look for the documentation of a function or we even look for a function. We may use Microsoft documentation (https://docs.microsoft.com/fr-fr/power-query/). But there is an other way much more comfortable for my needs: access to M functions documentation within Power Query How to Add a blank query and name it ‘Shared’ Open the advanced…