BenchMark Quizzes by MDFT Pro

Prevent Errors And Build Exception Report In Power Query

You are a report owner at MDFT Pro. 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.

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.

Learn more about error handling in Power Query:

Power Query Error Handling

Exam Preparation Quiz

Prevent Errors And Build Exception Report In Power Query