PL-300 · Question #463
You use Power BI Desktop to open a PBIX file that contains a Microsoft Excel data source. You attempt to refresh the data and receive the following error message. Expression.Error: The column 'Cost'…
The correct answer is A. The Cost column was renamed in the data source. Column of Table Not Found Errors occur when Power BI is unable to identify a column that was previously available. It typically occurs after updating a source file or changing a Power Query data transformation step. Common causes include column name changes, column removal, or…
Question
You use Power BI Desktop to open a PBIX file that contains a Microsoft Excel data source. You attempt to refresh the data and receive the following error message. Expression.Error: The column 'Cost' of the table wasn't found. What is a possible cause of the error?
Options
- AThe Cost column was renamed in the data source.
- BThe privacy level of the data source does not allow combining the data with other data sources.
- CThe data in the Cost column cannot be converted into the target data type.
- DThe source file was moved to a new location.
How the community answered
(47 responses)- A79% (37)
- B4% (2)
- C11% (5)
- D6% (3)
Explanation
Column of Table Not Found Errors occur when Power BI is unable to identify a column that was previously available. It typically occurs after updating a source file or changing a Power Query data transformation step. Common causes include column name changes, column removal, or a change in column position.
Community Discussion
No community discussion yet for this question.