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.
When encountering the error message 'Datasource.Error: Could not find file' in Power Query Editor, two plausible causes are: not having the necessary permissions to a file, which can prevent access and yield a 'file not found' error, and the file being moved to a different location, making the specified path obsolete and hence resulting in the error. Both situations can result in Power Query being unable to locate the file at the given path.
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."
https://learn.microsoft.com/en-us/power-query/dealing-with-errors
Do you have any tips for navigating Microsoft Learn to find the right article in the exam environment?
AD Seems correct
Missmatched Data -> A1
A: no permission on file or above because of heritance(folder/drive) D: file does not exist at mentioned location
A, D correct. references: https://learn.microsoft.com/en-us/power-query/dealing-with-errors
Do you have any tips for navigating Microsoft Learn to find the right article in the exam environment?
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.
why A ? because error will be "denied" and not "not found"
correct
correct answer
https://learn.microsoft.com/en-us/power-query/dealing-with-errors
Answer is correct
A,D correct in B and C cases you will receive different errors
I would say A and D. A if PBI cant find the file in the given path and D due this:https://community.fabric.microsoft.com/t5/Power-Query/SOLVED-Datasource-error-could-not-find-file/td-p/252703
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.