I’m trying to rerun my Power Query after updating a source file but whenever I run it, I get this error:

Steps to update source file:

Downloaded an updated source file from an internal dashboard to my downloads folder. The file type is CSV and the file name is saved as ContentAuthorReport ([Version #]).csv.Opened CSV and saved as XLSX file type, overwriting the pre-existing ContentAuthorReport.xlsx file in my Source Documents folder. 

I looked in the Source step and see it has the Name and Item columns set to the ContentAuthorReport (3). 

When I try to create a new query with the updated file just to see what comes up, ContentAuthorReport (4) appears.

I’ve checked the Info tab on the source XLSX document and the properties dialogue box but I can’t figure out why the version number is still attached to it or how to remove it.

I attempted to edit the code to remove the (3) but that didn’t do anything. Unedited code below:

Source = Excel.Workbook(File.Contents(“Source DocumentsContentAuthorReport.xlsx”), null, true),
#”ContentAuthorReport (3)_Sheet” = Source{[Item=”ContentAuthorReport (3)”,Kind=”Sheet”]}[Data],

I would like to be able to update this by just saving over the old source file so any help is much appreciated.

​I’m trying to rerun my Power Query after updating a source file but whenever I run it, I get this error: Steps to update source file:Downloaded an updated source file from an internal dashboard to my downloads folder. The file type is CSV and the file name is saved as ContentAuthorReport ([Version #]).csv.Opened CSV and saved as XLSX file type, overwriting the pre-existing ContentAuthorReport.xlsx file in my Source Documents folder. I looked in the Source step and see it has the Name and Item columns set to the ContentAuthorReport (3).  When I try to create a new query with the updated file just to see what comes up, ContentAuthorReport (4) appears.  I’ve checked the Info tab on the source XLSX document and the properties dialogue box but I can’t figure out why the version number is still attached to it or how to remove it. I attempted to edit the code to remove the (3) but that didn’t do anything. Unedited code below: Source = Excel.Workbook(File.Contents(“Source DocumentsContentAuthorReport.xlsx”), null, true),
#”ContentAuthorReport (3)_Sheet” = Source{[Item=”ContentAuthorReport (3)”,Kind=”Sheet”]}[Data],  I would like to be able to update this by just saving over the old source file so any help is much appreciated.   Read More

​