Power BI: Append Data From Multiple Sources To One Table

I love this video. Thanks for the easy explanation.

Great explanation on what happens with appending files having same and different column headers.
Thanks for explaining append and append as new query succinctly Matt.

Thank you

Nice. Helpful and complete. Good pace and level of detail. I now have greater confidence that I can append files with different formats easily.

Great video!!

This guy is amazing

Thanks for the video. I have two identical datasets: one is a historical data and saved as a csv file and the other one is from an API which gets refreshed everyday. I have built all my dashboards based on the API. Now if I follow your steps and append the historical one with the API one, does the data that’s coming from API in the appended table still gets updated or it overwrites the historical one as well? I need to keep the historical data fixed and refresh the API data daily.

So helpful, thanks!

How can we append similar records from different Excel records into one before procedding to next step. e.g. we have an identical table but in several different workbook or worksheet but for different classess which is used by different teachers, how they can all be added for anylize into a one master table or worksheet/workbook?

Did you ever create a video for appending files automatically from a folder? This sounds really cool! :)
BTW I've liked and subscribed!

can i do this with different data sources? for example Oracle and SQL Server?

Easy to follow video and worked for what i need it for. Thank you.

Good luck with maintain these excels. It's good solution for one time report. Better is agree and keep same format across all files and upload all files in one process in Dataflow/Query. And it's even better because you'll get 1 extra column with source file name. So you will know exact from what file came data you looking at.

Thanks for sharing! 👍

Thank you for this.

Yes please, I will like to see how to append from a folder. Thanks

Great timing ! Thank you ,

Excellent explanation of the Append process. Please create video with the Append from folder