Prevent Errors And Build Exception Report In Power Query
You are a report owner at MDFT Academy. You are importing a dataset with a dynamic column, which may change format occasionally and cause errors. You want to ensure that errors do not disrupt the refresh process and that you can investigate them later.
You need to prevent these errors from showing in the refresh and build a detailed exception report for further investigation. Which actions should you perform to achieve this?
Choose all correct answers from the options below.
Please select at least one answer!
Correct!
I'm sorry, your answers are not correct.
Explanations for each answer:
Remove the column that could generate errors is incorrect. Removing the problematic column prevents errors, but you may lose important data.
Replace errors with empty values by selecting Replace errors is incorrect. Replacing errors with empty values prevents errors from showing, but does not provide details for investigation.
Create two references of the main dataset: one reference for cleaned data, and one reference for error logging is correct. Creating references allows you to separate error handling from the main data processing.
In the reference dataset for error logging, create a custom column to catch the errors is correct. A custom column can be used to catch and log errors for further investigation.
In the reference dataset for error logging, select Keep Errors is correct. Keeping errors in a reference allows you to build a detailed exception report.
Unselect Enable load on the original dataset is correct. Disabling load on the original dataset prevents errors from being loaded into the model.