Import ONLY The Latest File

Import ONLY The Latest File - Power Query

Рет қаралды 19,961

Күн бұрын

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!
Instructor Lead Excel Course ► essentialexceluk.com/products...
More Tutorials ► essentialexceluk.com/blogs/tu...
#powerquery #importdata #msexcel #latestfile #tutorial

Пікірлер: 29

@EssentialExcel 2 жыл бұрын

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

@esthercraft 6 ай бұрын

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 2 жыл бұрын

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

@theErosenninfull 8 ай бұрын

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!

@KevinStudent 2 жыл бұрын

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

@paulgallagher2987 2 ай бұрын

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

@VanzJTutorials 9 ай бұрын

Great help...Thanks

@FRANKWHITE1996 2 жыл бұрын

Great. Thanks.

@user-ed7zd5dl7u Жыл бұрын

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

@mtarlo 3 ай бұрын

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?

@Urena10924 2 жыл бұрын

Thanks!

@mindaugasm2980 5 ай бұрын

thanks, you saved me :)

@fezzsmusic Жыл бұрын

Massive help thank you

@EssentialExcel Жыл бұрын

Thanks Matt, glad it helped! 🙂

@fezzsmusic Жыл бұрын

Keep up the good work, QQ im new to power query and im trying to find a way that i just get the top 6 files from a folder ( this is where this video helped perfectly) but the next part im stuck with is that i need pull specific sheet names, my sheet names are just dates in this format 01.01.2022 for example and i need it to pull if the date was yesterday. Is this possable in power query?

@EssentialExcel Жыл бұрын

Thank you! This is certainly possible with a number of ways to achieve the same result. You could filter on name using a calculation (within the filter) to format yesterdays date to match your file naming style. You could add new calculated column to do similar test to match file name to yesterdays date and filter on that column. If stuck I could take a look in morning and share a suggestion with you 🙂

@fezzsmusic Жыл бұрын

Thank you again, i did it slighty differently in the end i managed to do it with a series of filters, it also kept referencing a sheet name which i edited to allow it to be open instead. Really appreciate your response. I look forward to your future videos.

@ExLDS Жыл бұрын

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

@kirandeepkaur4292 2 жыл бұрын

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

@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 ?

@esthercraft 6 ай бұрын

it will pick up the top row, but when you expand your binary file, it will hardcode your file name and you have to keep on changing your file name everytime. This binary.combine - will pick up the latest folder and expand your contents of your table without having you to change the source name of your file everytime

@albertrondon3038 Жыл бұрын

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

@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?

@EssentialExcel Жыл бұрын

Hi Noel and thank you for subscribing! 😃 If the data is sensitive to each member then I don’t think there is a secure way I would recommend for doing this in Excel. One solution could be to use Forms. You could then send staff members the link to the form from which they can then enter and submit required data. This is a previous video we did using forms: kzfaq.info/get/bejne/pL5poqikq7DUnWg.html