exam questions

Exam PL-300 All Questions

View all questions & answers for the PL-300 exam

Exam PL-300 topic 1 question 25 discussion

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

From Power Query Editor, you attempt to execute a query and receive the following error message.

Datasource.Error: Could not find file.

What are two possible causes of the error? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

  • A. You do not have permissions to the file.
  • B. An incorrect privacy level was used for the data source.
  • C. The file is locked.
  • D. The referenced file was moved to a new location.
Show Suggested Answer Hide Answer
Suggested Answer: AD 🗳️

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
andrewkravchuk97
Highly Voted 1 year, 8 months ago
So, the correct selections would be: A. You do not have permissions to the file. D. The referenced file was moved to a new location. Other options cause another message: B. If an incorrect privacy level is set for a data source, you might receive an error related to data privacy like: "Formula.Firewall: Query 'QueryName' references other queries or steps, so it may not directly access a data source. Please rebuild this data combination." C. If a file is locked, for example because it is open in another application and that application has locked the file for exclusive access, the error message might be something like: "DataSource.Error: The process cannot access the file because it is being used by another process."
upvoted 58 times
...
Romain_D
Highly Voted 1 year, 8 months ago
Selected Answer: AD
https://learn.microsoft.com/en-us/power-query/dealing-with-errors
upvoted 7 times
edbf978
1 year, 3 months ago
Do you have any tips for navigating Microsoft Learn to find the right article in the exam environment?
upvoted 1 times
...
...
720b680
Most Recent 4 months, 1 week ago
Selected Answer: AD
So, the correct selections would be: A. You do not have permissions to the file. D. The referenced file was moved to a new location.
upvoted 1 times
...
rcaliandro
8 months, 2 weeks ago
Selected Answer: AD
Can be either A. You do not have permissions to the file. OR D. The referenced file was moved to a new location.
upvoted 1 times
...
Kiran37
9 months, 1 week ago
correct answer
upvoted 1 times
...
bipin24x7
1 year, 1 month ago
Selected Answer: AD
AD Seems correct
upvoted 2 times
...
RedRoss
1 year, 1 month ago
Selected Answer: AD
https://learn.microsoft.com/en-us/power-query/dealing-with-errors
upvoted 1 times
...
HoatBQ
1 year, 1 month ago
Missmatched Data -> A1
upvoted 2 times
...
Dani_eL
1 year, 2 months ago
Selected Answer: AD
A: no permission on file or above because of heritance(folder/drive) D: file does not exist at mentioned location
upvoted 2 times
...
Dsbuff
1 year, 4 months ago
Selected Answer: AD
A, D correct. references
upvoted 2 times
edbf978
1 year, 3 months ago
Do you have any tips for navigating Microsoft Learn to find the right article in the exam environment?
upvoted 1 times
...
...
Nuli
1 year, 4 months ago
Answer is correct
upvoted 1 times
...
mordaro
1 year, 5 months ago
Selected Answer: AD
A,D correct in B and C cases you will receive different errors
upvoted 1 times
...
Igetmyrole
1 year, 7 months ago
A & D are correct answers. A. You do not have permission to the file: if there is no permission to access the file, you will encounter this error. D. The referenced file was moved to a new location: if the file that that query is trying to access has been moved to a different location or path, Power Query won't be able to find it, resulting in this error. We should verify the file's location and update the data source settings accordingly.
upvoted 2 times
...
nicknam123
1 year, 8 months ago
why A ? because error will be "denied" and not "not found"
upvoted 2 times
...
madyjoe21
1 year, 8 months ago
Selected Answer: AD
I would say A and D.
upvoted 1 times
...
MEG_Florida
1 year, 8 months ago
Selected Answer: AD
correct
upvoted 2 times
...
Bamlaku
1 year, 8 months ago
Selected Answer: CD
Two possible causes of the error Datasource.Error: Could not find file in Power BI are: The referenced file was moved to a new location: If the file you are trying to connect to as a data source has been moved or renamed, Power BI will not be able to find it and will display this error message. The file is locked: If the file is open by another person, it may be locked and cannot be accessed until it is closed.
upvoted 1 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
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago