Exam PL-300 All Questions

View all questions & answers for the PL-300 exam

Exam PL-300 topic 2 question 69 discussion

Actual exam question from Microsoft's PL-300

Question #: 69
Topic #: 2

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.

A. The column was removed from the source file.
B. The column was renamed in the source file.
C. The file is no longer in the specified location.
D. The data type of the column was changed.

Show Suggested Answer

Suggested Answer: AB 🗳️

by Akhilesh_Maithani at March 29, 2023, 6:48 p.m.

Comments

Submit Cancel

jiriz

Highly Voted 2 years, 2 months ago

Selected Answer: AB

correct

upvoted 23 times

...

Starvosxant

Highly Voted 1 year, 6 months ago

All the questions of those who upvote this comment will be at this level of difficult on the exam 🙏🙌

upvoted 20 times

jabbarjutt

1 year, 6 months ago

bruh this isn't reddit, why are u even asking for upvotes here ?

upvoted 4 times

...

jaume

Most Recent 7 months ago

Selected Answer: AB

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

upvoted 1 times

...

rcaliandro

10 months ago

Selected Answer: AB

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

upvoted 1 times

...

AZFabio

1 year, 3 months ago

Selected Answer: AB

correct

upvoted 3 times

...

Dani_eL

1 year, 3 months ago

Selected Answer: AB

the question is about a column, not the file in itself

upvoted 2 times

...

LawAninye

1 year, 9 months ago

The error message is column specific Error: The column 'Category' of the table wasn't found. Both option A and B in in line with this

upvoted 3 times

...

Igetmyrole

1 year, 9 months ago

A & B are correct answers. A. If the column 'Category' was present in the source file when the query was initially loaded but has been removed from the sources file since then, you would encounter this error when attempting to reload the query. B. If the "Category" column in the source file was renamed after the query was initially loaded, power query wouldn't be able to find the column with the original name, resulting in the error.

upvoted 5 times

...