PL-300 Question 117

Community Discussion

Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.

• Chose AB2

  * Answer: A. The column was removed from the source file. - If the Category column was deleted in the Excel file, Power Query will fail when it tries to reference it. B. The column was renamed in the source file. - If the column header was changed (e.g., from Category to ProductCategory), Power Query won’t recognize it because it’s looking for the original name. * Why not the others: C. The file is no longer in the specified location. - If the file were missing, you’d get a “file not found” error, not a missing column error. D. The data type of the column was changed. - Changing a column’s data type (e.g., text → number) won’t make the column disappear. You’d only see errors in type conversion steps, not a “column not found” error.

• Chose AB1

  Error is refering to a single specific column not found so it has been removed or renamed and that's why cannot be found. If the entire file (option C) would have been removed from the location, error message would not refer to a specific column in the data table. If data type would have been changed, could result in different errors in the query once l data has been retrieved but not retrieving the data

• Chose AB1

  A,B correct it can be either the column has been renamed or deleted as well