Item name changed for combined excel sheets and now throwing out error

[PJHos]

Hi all,

I have combined 2 excel sheets in power bi. Both have same column headers etc.. and worked fine until recently 

The source item name has changed and this is now throwing up errors. This has happened for the excel sheets I have uploaded without combining and they were easy enough to correct but I cannot seem to be able to find where I can edit this. tried Power Query but i do not understand it well enough to be able to see how to correct this issue

An error occurred in the ‘Transform File (2)’ query. Expression.Error: The key didn't match any rows in the table.
Details:
Key=
Item=Store Site Product Items
Kind=Sheet
Table=[Table]

Store Site Product Items has now changed to Product items

[HarishKM · Accepted solution]

@PJHos Hey ,
You can try 2 things.
you can have to this solution Combine Files With Inconsistent Columns In Power Query .

2nd solution
You can rename this Store Site Product Items has now changed to Product items. You can find that in step 4 or you can add it in step or If not then add this column before last step .

#"Renamed Columns" = Table.RenameColumns(#"Changed Type",{{"Store Site Product Items", "Product items"}})
in
#"Renamed Columns"

Kindly mark solution accepted if it is fulfill you requirement and give kudos too.

[PJHos]

Wow!!

Thank you, I used the video and found the answer

Thank you so much, I had been stumped on this for ages and was half tempted to rebuild this section of my reports.

Saved me a lot of time 😀

[amitchandak]

@PJHos , check that there will be some steps using that renaming or using the old column name, this seems like an issue there

[PJHos]

Hi thank you for taking the time to reply

For the files where the excel sheets were uploaded without combining the 'applied steps' shows me a 'navigation' step. I can select this step rename the 'item' (file name). Once this has been done it then provides a preview of the sheet in the centre window and hence, allows me to navigate through the sheet to rename columns. However, I cannot find the nvagiation applied step for these combined sheets to be able to make this change which inturn will allow me to make changes to column names.

The last step in the 'applied steps' is 'changed type'. I have made relevant changes to column names but I am still getting the 'item' name error