Skip to content

Instantly share code, notes, and snippets.

@IvanBond
Created June 8, 2019 13:45
Show Gist options
  • Star 2 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save IvanBond/9f56f87d3663ac0744e912643682d754 to your computer and use it in GitHub Desktop.
Save IvanBond/9f56f87d3663ac0744e912643682d754 to your computer and use it in GitHub Desktop.
Get USERNAME in Power Query
let
Source = Folder.Contents("C:\Users"),
// filter out Public folder as it may be accessed by scripts
#"Filtered out Public" = Table.SelectRows( Source, each [Name] <> "Public"),
// sort to get last accessed in the top row
#"Sort by Date accessed" = Table.Sort( #"Filtered out Public", {{"Date accessed", Order.Descending}}),
// filter out potential system folders
#"Expanded Attributes" = Table.ExpandRecordColumn(#"Sort by Date accessed", "Attributes",
{"Kind", "ReadOnly", "Hidden", "System"},
{"Kind", "ReadOnly", "Hidden", "System"}),
#"Filtered Kind Folder" = Table.SelectRows(#"Expanded Attributes", each [Kind] = "Folder"),
#"Filtered ReadOnly" = Table.SelectRows(#"Filtered Kind Folder", each [ReadOnly] = false),
#"Filtered Hidden" = Table.SelectRows(#"Filtered ReadOnly", each [Hidden] = false),
#"Filtered System" = Table.SelectRows(#"Filtered Hidden", each [System] = false),
// get username from the first row
#"First Row" = Table.FirstN( #"Filtered System", 1 ),
Name = #"First Row"[Name]{0}
in
Name
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment