22-25 April 2026 
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".
Speakers
Ana Maria Bisbe York's previous sessions
Let's define Entities and attributes for tabular models in 20 minutes.
Examples from real-life projects that demonstrate the issue and improve the design of entities for the tabular models.
Lets play with a date field & Time Intelligence in Power BI
Date fields play an important role in virtually all cases of advanced analytics. The "problem & solution" style session can be very useful given the large number and variety of scenarios that may arise
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.
Some transformations that can save your ETL in Power BI
To build analytical models, we need to start by extracting, transforming, cleaning, preparing and loading the data. This session analyzes a set of scenarios that may happen during the ETL step using the Power Query in Power BI.