After a CSV file was imported to the excel file, the excel sheet will have connection with the CSV file. If the CSV file was deleted or moved to other folder, you might get the data source error when you try to refresh the data connection:
To quickly fix this error, Open the excel sheet, click menu “Data” > “Queries & Connections” to open the “Queries & Connections” panel, which normally is on the right side of the excel sheet.
On the “Queries” tab, double click the query that has issue.
This opens the “Power Query Editor” window. Click Menu “Home” > “Advanced Editor”
On the “Advanced Editor” pop-up window, modify the Source, enter the new Absolute Path of the CSV file. Click Done. This should update the data source.
Another thing that worth to mention is the encoding setting. I have to change the encoding to 65001, which is “UTF-8”, (Encoding=65001), in order to display some French characters in the CSV file.
