Load the Latest File in a Folder in Power Query M

Loads only the most recently modified file from a folder, instead of every file in it.

File HandlingIntermediatefolderlatest filemodified date

Power Query M code

let
    Source = Folder.Files("C:\Data\Reports"),
    SortedByDate = Table.Sort(Source, {{"Date modified", Order.Descending}}),
    LatestFile = Table.FirstN(SortedByDate, 1),
    Content = LatestFile{0}[Content],
    Imported = Csv.Document(Content, [Delimiter = ",", Encoding = 65001])
in
    Imported

Notes

Swap Csv.Document for Excel.Workbook if the latest file is a workbook instead of a CSV.

Requirements

A folder where only the newest file should be loaded each refresh.

How to use this snippet

In Power BI Desktop, choose Transform data to open Power Query, then open the Advanced Editor on a query (or start from a blank query).
Paste the snippet and replace the placeholder names (tables, columns, file paths) with your own. Check the requirements above first.
Run it through the Power Query M Formatter to tidy the layout.

Related Power Query M snippets

More Power Query M resources

Browse all 145 snippets in the Power Query M Code Snippets, or search the library for something similar to Load the Latest File in a Folder.