Netherlands Antilles •
Request Pricing
About
Trained 1000+ students, can explain difficult topics clearly in fluent English with a touch of humor
Error handling like a pro in Power Query
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
Introduction to Power Query Language M
M is the formula language behind Power Query. Every transformation you apply to your data is translated into M code. Knowledge of this language opens doors that remain closed when you only use the graphical interface. In this session you will learn what else is possible by using the Advanced Editor, such as: - Working with variables and data types - Custom Columns and Time Intelligence Filtering - Data grouping and sorting - Creating table and scalar functions - Crossjoin between 2 tables (make all possible combinations) Recently, the Advanced Editor also has Intellisense, so now is the time to delve into M!
Your perspective matters!
What was it like engaging with Arthur?