Error message: XX column cannot be found after change folder path

Dear community memebers,

Recently, I set up a file with the folder as the data source. The folder is located in a shared drive, where credential is needed.

I would like help my colleague to set up this power BI file in his own laptop with the data source folder located in his department's drive. Therefore, I just changed the folder path in the advanced editor for both the sample file and the main query.

The change for the sample file works well. However, when my colleague changed the folder path for the main query, an error message poped up, saying that XXX(column name) is not found.

I cannot figure out which part went wrong, since the data source files are totally the same, only the folders are located in different shared drive with different credentials. I also tested it in my laptop with different folder paths and everything runs smoothly. We use the same pbix file and same csv files saved in the folder, but the issue happens to my colleague. (he has the credential for his source folder, so I assume that credential is not the point.)

Does anyone has idea what causes this issue?

Thank you very much!