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.
The Power Query M function reference includes articles for each of the over 700 functions. These reference articles are auto-generated from in-product help.
If you're familiar with using Excel functions (and of course you should be) then you'll know that a function typically takes some input and gives you an output.
Hidden inside both Excel and Power BI is a secret Power Query function list that you can bring up while working in the Power Query editor window…that’s if you know the magic word.
Power Query has over 600 native functions and the Power Query team keeps adding more and more.
I wouldn’t recommend memorizing them, but you do need to understand the concept of parameters and arguments in order to understand what functions are.