Import ONLY The Latest File - Power Query

How to import only the latest file with Power Query?!

In previous videos we have demonstrated how to combine all files within a folder / location but in this video we demonstrate how you can import just the latest file! In the tutorial we demonstrate how to achieve this where each file name conveniently contains a date stamp, but this is just one method you can use to achieve the result.

In this example we use Power Query within Excel, but the content in this video is the same and transferable to other applications that use Power Query such as Microsoft Power BI.

If you are new to the channel or watched out videos before, please consider subscribing and if you enjoy the video don't forget to give it a like!

#powerquery #importdata #msexcel #latestfile #tutorial

[EssentialExcel]

I hope you enjoyed this tutorial 😃 If you did please give it a LIKE... and don’t forget to SUBSCRIBE for even more content!

[esthercraft]

THis the bestest of the bestest solution for Power Query to dynamically to up your latest folder dynamically without having to keep changing the source name!!!!

[vanitravels]

This video was so helpful and clearly explained. Thanks so much!

[theErosenninfull]

Thank you so much! I used this on PowerBI to get the latest file depending on the Date from a SharePoint Online folder, now its working!

[edzddlu]

Oh my, you saved my computer from being thrown out the window. Thank you so much!🎉

[mtarlo]

Great video, and what i was looking for, the only thing i am now trying to work out is how do i incorporate the relative folder (movable folder ) into this? so it will refer to the folder no matter where it is, instead of a defined location?

[KevinStudent]

Very helpful! Ran into the exact issue from the beginning where it "locked" the file name from when I created the query. Easy fix!

[paulgallagher]

Thanks for this. @6:30 does the Binary.Combine function only work on csv files or would it work on .xslx files too?

[TheCyab]

Thank you for such a detailed video. How does this work on a xlsx file? It doesn’t seem to import the data on the binary content step

[netinterested]

Does it work the same for multi tab xlsx source files?

[ExLDS]

@essentialexcel . I cannot figure a way to not mess up my query if the sample file is gone. How can I fix this?

[Gudha_Ismintis]

Hi, new subscriber here;

Background: i have a master spreadsheet at work, the sheet has thousands of rows and dozens of columns. 1 of the main columns has the names of a significant number of staff members (which are not in order because rows have been gradually added over time to represent that staff member - which brings me to my question)

Question: i want these staff members to fill in the subsequent columns that belong to them all the way up and down the spreadsheet - BUT without seeing the overall spreadsheet that contains the other columns for the other staff members entering their data - is there a way perhaps to do this?

[crazycxr]

I have to try this out on my self first but I quite dont understand the binary stuff after sorting by date the files in the folder... to me if you sort the folder files by date, the Power Query commands would be dynamic, isnt it ?

[kirandeepkaur]

Hi I tried this however when I type binary., no “suggestions” show up ? Do you know how to solve?

[albertrondon]

This only works on CSV file. How about for xlsx file?

[gamesmac]

but how Import ONLY The Latest two File-using power query

[johnm]

This method deletes files... wow... thanks.