Excel Incremental Data Load with Power Query

ExcelChef - 7/101 - Incremental Data Load with Power Query

Getting new files every month that have the same name but different data? Here's a quick tutorial on loading data consistently from such files for analysis / reporting.

This is the 7th video in the ExcelChef 101 Series. 94 more to go...

What excel topics would you like me to post? Share your feedback in the comments. 📢 Please share this post with friends and colleagues - Who knows you might help them decrease their excel workload!

#excelskills #exceltips #exceltutorial #exceltricks #excel #msexcel #excelonline #exceltraining #excelformulas #exceltipsandtricks #exceldataentry #powerquery #PowerBI #PowerPivot #webscraping

[ClydeManchester]

Excellent. This has solved so many problems for me and will save me so much time. Thank you very much

[jsalais]

Excelent and simple, i did it before, do it 5times more effort and formulas, the best and simple solution
thks

[salvadorrequenasilla]

Great tutorial!!!! Very smart aproach!!!

[Gnillors]

Nice Approach, thanks! What if I want to replace one of the months I have already downloaded, because there have been some updates? For example let´s say I updated March Data a few days ago, and now March Data is updated (some lines removed / changed, etc). How can I do to replace the old data I have uploaded and only append the lastet data. In this case remove duplicates will not work. I need to remove all the lines with date March from the already loaded data...

[SndfOmar]

Thank you for the useful and neat information.
Deserves a Like & Follow.

[mabram]

PERFERCT ! that's what i was looking for !

[Bloxsters]

thank you so much, I have Table and I needed to send every month to the team and update while I wanted to keep historical data and present it in my power bi report,

[edme]

Excellent ! I developed a solution to add a Power Query result to a non Power Query table, with some VBA. But this is better because it doesn't need VBA. Great job, much appreciated. Subscribtion well earned. Thanks and keep up the good work.

[universo]

im really loving smart indian guys like you my friend

[secondschallenge]

That is awesome. Can we schedule refresh all option?

[ubaidillahmuhammad]

nice job. please put excel file in the description video

[cherefcheref]

Thanks for this video. How to refresh current year sales only in excel table using power query without changing prior years actual data in the same excel table. Thanks

[bernardosantos]

That's awesome. Exactly what I'm looking for. I'm actually trying to replicate incremental load in Power BI and my source is a SQL Server table that gets updated daily. I want to keep the daily snapshots. Will this work aswell? Thank you so much

[ExplorewithNonz]

Not working for me... not sure why 😞.... but this is the solution I am looking for

[harshchovatiya-ghhn]

I have very large data more than 10 lacs in each file. So i cant load the data into table as shown. Can you make this video for the same? Or suggest me the steps

[npnrxcm]

Hi it is very helpful video, but I want to load monthly incremental data having 1.5 Lac for each month. so considering this I am unable to load beyond 7 months data. if you can share some alternative solution to this will be very helpful.

[toirtr]

Not useful for the Use Case when you want to load ! incrementally! data from the same database/table. The term 'incremental' means you load only partial subset, Not as in your example: Load everything and then just rewove duplicates. I would rather name the video: How to merge 2 sources and remove duplicates. -^)