Import ONLY The Latest File - Power Query

Подписаться 21 тыс.

Просмотров 20 тыс.

50% 1

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

Опубликовано:

6 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 30

@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 👉 ru-vid.com

@DuniyaJahan1 3 дня назад

Great 😮

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

@theErosenninfull 9 месяцев назад

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!

@user-ed7zd5dl7u Год назад

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

@vanitravels 2 года назад

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

@FRANKWHITE1996 2 года назад

Great. Thanks.

@paulgallagher2987 3 месяца назад

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

@VanzJTutorials 10 месяцев назад

Great help...Thanks

@Urena10924 2 года назад

Thanks!

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

@mindaugasm2980 5 месяцев назад

thanks, you saved me :)

@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

@mtarlo 4 месяца назад

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?

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

@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

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

@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: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-nX9oEsFJpm4.html