Append vs Merge in Power BI and Power Query

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

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

excellent tutorial, thank you!

Perfect video to explain difference between merge and append

Hi,
i am trying to combine three excel sheet,one sheet contains header and other sheet does not contains header details,I have selected example file as first sheet ,i am getting data from only from first sheet not from other sheet.
can you pls guide me on this ?
or is it possible to combine that one sheet with header and other sheet without header ?

Simply, thank you!!

Awesome!

Is it possible to combine two tables without having no single column same so what can we do in power query?

Is it possible to merge 3 tables together in powerbi?

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?

can we not merge more than two data sources in power query ?

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

Clear, concise, excellent. Thank you

Reza, thanks for understandably explaining these two functions.

Hi , Can we merge data from SAP BW and Salesforce Table. I have one set of data say targets in the salesforce and targets achieved in SAP BW. Can i do the visualization in Power BI

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

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.

Informative and thorough, thank you!

Thanks Reza for this clear and thorough tutorial

You just saved my job! Thank you.

Hey man, i have a situation and I want your advice. So i am making a dashboard in which data comes to a table after every 5 min automatic refresh. User wants the history of data. Now if i use append so after every refresh, the data will get into a new appended table. Now the issue is after every refresh data will take place of previous data, I don’t want that. I want if first refresh have 20 records and second have 30 records then total after 2 refreshes should be 50 records instead of 30 in the new history table. But this is failing and user wants the whole data. Could You please help me how can I achieve this? Tell me if you want more explanation. Looking forward for your reply.

Thanks, man, you're the best.

Could I make calculations among different tables without using merge?

Thank you very much ! It was very simply explained & understand the concept

Radacad, can you provide a solution to the need of stacking records in more than 2 column's (let's say 3 or more) data into one single column in powerBI / powerQuery Thank you

Thank you Reza, this is very helpful!

Thankq soo much

Best Explanation Ever! Loved it

Query folding & Incremental refresh

You are awesome in Explaining everything in an easy way... Fabulous. Many many many Namaskars🙏🙏🙏🙏🙏(Indian style) & thanks a lot. I almost saw all your videos

Hi, thanks for the video it's helps a lot, I just have a question actually i've created a merged table but it doesn't take new columns that are added into the first table till i select them from the list, is there a way to developpe newcolumns automaticaly i want to select them all at once without adding every time the new one

Hey pls can u help me, what if we have two tables and we need to merge those two but theres no primary key and foreign key (no common column)

Thanks 😊

sir I need more in power query................................jazakallah,

Geat video, many thanks for the sharing.

Great tutorials as usual Reza, well done.
I have smal question, I have 10 folders containing information related to 10 assets / equipment. Inside each folder, I have 12 files where each file contains the monthly data related to the particular asset. So in total I have 120 files providing information for 1 year.
All these 120 files shares a common column which is the timestamp based on hourly data gathering. However remaining column headings are different (equipment-1 run hour, equipment-2 run hour, etc…).

What do you suggest for combining all into single table based on the common timestamp. Do I need to combine each asset table separately into single table and then merge all the 10! Thnk yoy.

If you need to both Append and Merge, is it better/more efficient/effective (from a memory standpoint, etc.) to Merge and then Append, or Append and then Merge?
Thanks.

Thank you for your clear explanation.

You explained very well. Thanks for sharing. I just subscribed your channel 👍🏻

Great and Clear explanation. Thank you. I found this to be very helpful. I have subscribed!

THE WAY YOU TEACH IS AWESOME.

Append is like union all

Thank you for this Vedio..

Thank you for explaining it so well!

Great video, thanks!

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