Excel Incremental Data Load with Power Query

Подписаться 302

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

50% 1

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!
Checkout my email course in Hands-On Business Analytics - hi.switchy.io/handsonbusiness...
#excelskills #exceltips #exceltutorial #exceltricks #excel #msexcel #excelonline #exceltraining #excelformulas #exceltipsandtricks #exceldataentry #powerquery #PowerBI #PowerPivot #webscraping

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

25 май 2021

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

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

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

@the-excel-chef 3 месяца назад

Glad it helped!

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

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

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

@the-excel-chef 11 месяцев назад

Much appreciated!

@salvadorrequenasilla6553 2 месяца назад

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

@the-excel-chef 2 месяца назад

Glad you liked it

@mabram2055 Год назад

PERFERCT ! that's what i was looking for !

@yousefabdelsamie5983 2 месяца назад

Perfect, thank you!

@the-excel-chef 2 месяца назад

Glad it helped!

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

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,

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

great help, works perfectly

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

im really loving smart indian guys like you my friend

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

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.

@the-excel-chef 9 месяцев назад

Thanks. Great you found some value in this.

@viveksharma4193 Год назад

Absolutely fantastic You nailed it.

@the-excel-chef Год назад

Thanks. Your comments are getting me charged to restart my series of videos. What are some topics you would love to see?

@viveksharma4193 Год назад

M code realted in power query...list function .unstack column in power query.

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

That is awesome. Can we schedule refresh all option?

@ubaidillahmuhammad20 7 месяцев назад

nice job. please put excel file in the description video

@cherefcheref2664 6 месяцев назад

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

@the-excel-chef 5 месяцев назад

Prior years data shouldn't change with this approach.

@sandeepdeore9063 Год назад

How to do the exact thing in Power BI

@robertbencze8205 6 месяцев назад

what if you copy the feb data again?

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

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

@kreecha4409 Год назад

did you find a solution, this is what I'm trying to do as well

@the-excel-chef Год назад

Thanks. Your comments are getting me charged to restart my series of videos. What are some topics you would love to see?

@derbasti1123 Год назад

@@the-excel-chef I am looking for a way to do an incremental load, which would append not only after the last row, but would also add rows in between (based on an ID coming from an external system). And the historic data has been appended manually by additional rows, who need to keep their connection to the original ID.

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

This will not work if you want to replace with the right data previous data that you already haf

@ExplorewithNonz Год назад

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

@harshchovatiya-gh7hn Год назад

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

@the-excel-chef 11 месяцев назад

I know its too late.. but have you checked this video- ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-NaM8MnDv43s.html You can load the data but you will have to use a power pivot to analyze it. you can't view the rows as there is a row limit in excel.

@user-np2nr6xc9m 11 месяцев назад

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.

@the-excel-chef 10 месяцев назад

You would need a database to store the data or store data in multiple csv files and use powerquery to connect and analyse the data.

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

@@the-excel-chef Hi Thanks for the solution. but can I add new sheet in excel dynamically after the row limit reaches?

@toirtr 8 месяцев назад

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. -^)

@the-excel-chef 6 месяцев назад

Well its the incremental load equivalent with excel :)