Dec 13, 2022 12:00 AM

Power Query: Introduction [Power Query in Excel and Power BI Series - Ep. 1]

External YouTube Channel

In this video, Allison goes into Power Query in Excel and in Power BI and shows how you can do some basic transformations in the Power Query program in both ...

In this video, Allison goes into Power Query in Excel and in Power BI and shows how you can do some basic transformations in the Power Query program in both excel and in Power BI.

She goes over what is the same and the differences between the way you access the program in both programs. She then goes through the interface and shows all of the buttons as options. Allison also shows how to remove columns as well as to add new ones in with Column From Example.

Power Query Functions Overview

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.

https://learn.microsoft.com/en-us/powerquery-m/power-query-m-function-reference

Power Query Custom Functions

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.

https://www.myonlinetraininghub.com/power-query-custom-functions

How to Uncover the Hidden Power Query Function List!

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.

https://www.youtube.com/watch?v=5a0dlTAEr2E

Parameters and Functions in Power BI / Power Query–Custom Functions

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.

https://www.thepoweruser.com/2019/02/19/parameters-and-functions-in-power-bi-power-query-custom-functions/

More about Power BI

https://www.hubsite365.com/en-de/news?id=b924b3d9-6e45-ed11-bba2-6045bd8f953f&topic=47b49196-e1e1-ec11-bb3c-000d3a47c0cc