PowerQuery is a very efficient tool to extract and transform data and is now spreading to other products in the PowerPlatform stack and even Azure Datafactory. It’s very easy to select the transformations via the interface but you can end up with a lot transformation steps that might have a negative effect on the performance and how errorproof your queries are.

In this session I will talk about 10 different things you must know about PowerQuery in order to ensure performance, reliability and ease of maintenance – and this knowledge can be used in all the places you use PowerQuery.