The Power Query editor is a really great editor when transforming and importing data into your Power BI Model.
But it sometimes doesn't do exactly as we want. If you want to fully control what is happening in Power Query you must be aware of some of these pitfalls and begin to master the M language.
In my session I will illustrate some of these possible problems and how to handle them. This will require knowledge about parameters, the advanced editor and the core elements in the Power Query language - but don't be scared it's actually quite simple and will hopefully improve your queries speed and flexibility in the future.