ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam PL-300 All Questions

View all questions & answers for the PL-300 exam
Go to Exam

Exam PL-300 topic 2 question 69 discussion

Actual exam question from Microsoft's PL-300
Question #: 69
Topic #: 2
[All PL-300 Questions]

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 Hide Answer
Suggested Answer: AB 🗳️
by Akhilesh_Maithani at March 29, 2023, 6:48 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
jiriz
Highly Voted 2 years ago
Selected Answer: AB
correct
upvoted 23 times
...
Starvosxant
Highly Voted 1 year, 4 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, 4 months ago
bruh this isn't reddit, why are u even asking for upvotes here ?
upvoted 4 times
...
...
jaume
Most Recent 5 months, 1 week 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
8 months, 2 weeks 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, 1 month ago
Selected Answer: AB
correct
upvoted 3 times
...
Dani_eL
1 year, 2 months ago
Selected Answer: AB
the question is about a column, not the file in itself
upvoted 2 times
...
LawAninye
1 year, 7 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, 7 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
...
AyoJose
1 year, 8 months ago
Apart from this questions, can we also practice with Microsoft Assessment?
upvoted 1 times
...
abbeyabh
1 year, 10 months ago
A. The column was removed from the source file. B. The column was renamed in the source file.
upvoted 2 times
...
Shalaleh
1 year, 12 months ago
Selected Answer: AB
Correct
upvoted 2 times
...
RazaTheLegend
2 years ago
Selected Answer: AB
Answer is correct
upvoted 4 times
...
iplearing0123
2 years, 1 month ago
answer is correct
upvoted 3 times
...
Akhilesh_Maithani
2 years, 1 month ago
answer is correct
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago