'DataSource.NotFound: File or Folder: Could not find a part of the path' problem

[DerrickLang]

I am trying to work with a prior employee's file, but the data the dashboard pulls from is an excel file we do not have. The datasource returns the error:

DataSource.NotFound: File or Folder: Could not find a part of the path 'C:\Users\....xlsx'

Is there a way to adjust this or extract how the data was being pulled without having that file? The dashboard is a few months behind and I think the query furnishing the data source excel file was limited to a specific time frame.

[v-nmadadi-msft]

Hi @DerrickLang 

As we haven’t heard back from you, we wanted to kindly follow up to check if the suggestions  provided by the community members for the issue worked. Please feel free to contact us if you have any further questions.

Thanks and regards

[v-nmadadi-msft]

Hi @DerrickLang 

May I check if this issue has been resolved? If not, Please feel free to contact us if you have any further questions.

Thank you

[v-nmadadi-msft]

Hi @DerrickLang ,

I wanted to check if you had the opportunity to review the information provided by @danextian . Please feel free to contact us if you have any further questions.

Thank you.

[Shahid12523]

The PBIX is pointing to a missing local Excel file.

1. Check Transform Data → Data Source Settings → see/change the file path.
2. In Power Query, the Source step shows exactly how data was pulled.
3. If the Excel file is gone:

• You can still view query steps.
• If data was imported (not DirectQuery), check Data view → cached rows may still be there and exportable.

[danextian · Accepted solution]

Hi @DerrickLang 

If you dont have a copy of the Excel then the only option is to export the imported data which may have already been filtered and with some columns removed. If the data isn't too big, you can go to Table view, copy the whole table and paste it to Excel. If copying doesn't work because of the size, you can use an external tool called DAX Studio to query the table and export it to a file. You will then need to reroute to the new file from the data source settings whichmight not be very straightforward if some columns being referenced in the original query no longer exist because the exported alread have them removed.