PL-300 · Question #341
You have a Power BI data model that imports data from a Microsoft Excel spreadsheet. You use Power Query to load a query that contains both renamed and custom columns. Later, you attempt to reload…
The correct answer is A. The column was removed from the source file. B. The column was renamed in the source file. The 'column not found' error in Power Query indicates that the expected 'Category' column either no longer exists in the source file or has been renamed.
Question
You have a Power BI data model that imports data from a Microsoft Excel spreadsheet. You use Power Query to load a query that contains both renamed and custom columns. Later, you attempt to reload the query and receive the following error message. Expression.Error: The column 'Category' of the table wasn't found. What are two possible causes of the error? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
Options
- AThe column was removed from the source file.
- BThe column was renamed in the source file.
- CThe file is no longer in the specified location.
- DThe data type of the column was changed.
How the community answered
(40 responses)- A78% (31)
- C15% (6)
- D8% (3)
Why each option
The 'column not found' error in Power Query indicates that the expected 'Category' column either no longer exists in the source file or has been renamed.
If the 'Category' column is removed from the Excel source file, Power Query's steps will fail when attempting to reference a non-existent column during refresh.
If the 'Category' column in the source Excel file is renamed, Power Query will look for a column with the old name ('Category') and fail to find it, resulting in the specified error.
If the source file is missing, the error message would typically relate to the file's availability or connection, not a specific column within the table.
Changing a column's data type in the source typically leads to data type conversion errors later in Power Query steps, not an initial 'column not found' error.
Concept tested: Power Query data source error troubleshooting
Source: https://learn.microsoft.com/en-us/power-query/power-query-error-handling
Community Discussion
No community discussion yet for this question.