Forum Discussion

Jim_'s avatar
Jim_
Advocate I
9 years ago
Solved

DataSource.Error: Could not find file...

When I refresh a project I am working on I get the error listed above.  I can navigate to the file and open it.  Is there any known reason that BI would lose the ability to connect to a file?    
  • v-huizhn-msft's avatar
    v-huizhn-msft
    9 years ago

    Hi Jim_,

    Please click the file->Options and Settings->Data Source Settings, you will get the following data source settings navigator. Then select change source(highlighted in red line), please check the path and open file as right format.



    what's your data soure? I post an example using .xls file above. Please check if it works fine. Please share more details if you have still find other issue.

    Thanks,
    Angelia

dkay84_PowerBI's avatar
dkay84_PowerBI
Microsoft Employee
9 years ago

You can wrap anything in M with a "try <whatever you are trying to do> otherwise <do something else>"

 

Not exactly sure how to implement in your situation, but maybe there is a way to have PBI ignore the cases where the file is missing (and throws and error).

Anonymous's avatar
Anonymous
Not applicable
7 years ago

You just answered the question for me, thank You.

The way to fully enanble this is to add another last step where you ask M if the Source is equal to the otherwise statement and substitute it for the last previous step if it isn't.