Question 341 of 388
Choose 2You 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.
✓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.
✓
Correct Answer: A, B
The column was removed from the source file.
▥
Explanation
The correct answer is highlighted above. Review the wording carefully, then use the next question to continue building your understanding of Microsoft certification topics.