PowerPivot Reading from PowerQuery Error

[saudi_red_neck]

Hello friends, Hope all is well!

I used PowerQuery to pick up 12 CSV files from 1 folder, to create a PowerPivot table from the files. The PowerPivot worked and picked the contents of all the CSV files.

Today I added and the removed new CSV files, so I simply returned back to the exact 12 files.
I refreshed the PowerPivot and got the following error (please see image). What happened and how do I have the PowerPivot work again.

Your continuous amazing help is needed and always appreciated in advance!

[AliGW]

The error message tells you what the problem is. Close the file it is trying to read from and try again.

[saudi_red_neck]

OK, I figured Out the issue (in case anyone else does too).

After successfully making the PP, I renamed the workbook. That's why the refreshing couldn't recognize the file.
Here's what to do to fix it, please go to the following screens in PowerQuery.

[AliGW]

Have you tried rebooting your machine? Maybe something has been left in memory somewhere.

[AliGW]

Thanks for letting us know. That was going to be my next question! You have to be careful not to rename anything!!!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.