Append in Power Query [Power Query in Excel and Power BI Series - Ep. 2]

In this video, Allison goes into Power Query in Excel and in Power BI and shows how you can combine two data sources with the same column structure by doing an Append. She walks through bringing your data into Power Query, what you should keep in mind, and shows how to do the process. She also covers the difference between an Append and an Append as New. For this episode in the Power Query Series, we start with Power Query in Power BI and then show the steps are results in Power Query in Excel at the end.

-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -
Next step on your journey:

Let's connect:



Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: [phone]
#PragmaticWorks #AllisonGonzalez

[anthonymulweye]

This is so amazing, the teaching sinks deep. I'm eagerly waiting for the Merge video. Thanks alot for sharing knowledge.

[Liyakhat]

what if header of the data column is in a merged column will it be append? I am getting error while appending