Error handling like a pro in Power Query
2022TL; DR
Topics: Catch errors, filter out wrong data + files and create Error reports.
Session Details
How do you prevent unexpected data or incorrect files from blocking your dataset refresh?
In this session you will learn what options you have to make your Power Query ETL more robust, such as:
○ catch errors with try otherwise and error details
○ filtering out and logging invalid files
○ filtering and logging incorrect rows
○ Creating error reports
3 things you'll get out of this session
Speakers
Arthur Graus's previous sessions
Master Python in Fabric for Data Engineers
The world of data engineering is changing and being fluent in T-SQL is not enough anymore. In this full day workshop with lots of exercises you will get up to speed with Python and learn all the tips and tricks you need to know.
Python in Fabric for Data Engineers: all you need to know
The data engineering landscape is evolving. T-SQL proficiency isn't enough now. Dive into modern tools like Delta Lake, Jupyter Notebooks, and MS Fabric with Python. This session covers Python syntax, Jupyter in Fabric, data manipulation with Pandas, PySpark for Big Data, and data extraction/loading techniques for various formats.
Power Query formule language M for beginners
M is the formula language behind Power Query. Any transformation you apply to your data is translated into M code. Knowledge of this language opens doors that remain closed if you only use the GUI.