SQLBits 2020

Lets do the cleansing with M and / or Python languages

This short session will cover some scenarios of cleansing data in Power Query using M, Python, or both languages.

Power Query includes several options for transforming and cleansing data. However, there are situations when no native option is enough and we have to write some code using M language, or ... Python language. Which will be the best option? As always, it depends !! The session will cover some samples, after that, you will be able to decide and to have a better answer than "It depends".