Append vs Merge in Power BI and Power Query

Combining two queries in Power Query or in Power BI is one of the most basic and also essential tasks that you would need to do in most of data preparation scenarios. There are two types of combining queries; Merge, and Append. Database developers easily understand the difference, but the majority of Power BI users are not developers. In this post, I'll explain the difference between Merge and Append, and situations that you should use each.
here is the blog post of this video:

[MrChaitusk]

The tips you give in addition to explaining the concepts really help at the timer of interviews. Thanks a ton!!

[oveektron]

You are very brief yet explain everything related to a topic. So useful! thank you so much!

[jhewitthunt]

took me a while to find the answer to this. Quite straight forward in the end, so thanks for explaining

[brunotheozzo]

Very helpful!! Simple explanation covering very important aspects such as CPU performance and others. Congratulations!!!!

[huovfiy]

Reza, thanks for understandably explaining these two functions.

[christianlira]

Good day, Reza, and thank you for putting this video together. I learnt some new items within Power Query and thank you. Much appreciated.

[sara]

Thanks for that, I've created two views from a table in Power Bi and I'l like to merge them.But Power BI doesn't bring the view's name in Merge setting.
How can I merge 2 views with same structure with DAX?

[evangelinekiku]

Great video with great content and explanation! Thank you Sir and keep up with the hard work. These tips will help a lot during interviews.

[tyrannosaurusburke]

These are the kinds of software instructional videos that are best: ones that are direct and to the point. It's great review for me. Thank you!

[mbianalytics]

Well done Reza, your tutorials are super easy to understand and are very informative. The key takeaway from this tutorial is disabling query load (which I was not doing before).

[kebincui]

Thanks Reza for this clear and thorough tutorial

[bhakthasingh]

Thanks. Great teaching; no time wasted.

[lucynomnom]

Very well explained. Thank you so much!

[mashhc]

Clear, concise, excellent. Thank you

[MultiCreasey]

Thank you - excellent concise video. Thank you for taking to time to create and share.

[mastermo]

Perfect video to explain difference between merge and append

[abdulkhader]

Awesome Explanation... I liked it very much.. Saw 3 vedios on the same concept but all were shit.. Thanks to you..

[webersworld]

This is very helpful! However I have a slightly different situation- I have a file where I already have visuals completed using table 1. I need to add table 2 which has all the same columns, but I don't want to append because then I have to change all of visuals to the Append table. Is there a way to do this?

[kschantz]

Thank you for an easy, logical, and understandable explanation!

[taniasteenkamp]

awesome video tutorial thanks! very helpful