Refresh Error - "The key didn't match any rows in the table"

[AMBP73]

Hello everyone,

I am getting the following errors and am unable to resolve. Essentionally ALL of my queries are returning "The key didn't match any rows in the table" when I try to refresh through the desktop app from excel spreadsheets in SharePoint online. Below are some screenshots for context, but if anyone can provide some advice or links to logical problem solving steps (I have already trawled the internet to no avail) it would be much appreciated. Thanks in advance.

[christinepayton]

This will happen if you rename things in Excel - this includes sheet names, named ranges, file names, or column names. The sheet name is a biggie that people don't expect that can break it, if you go to the first step that has the error it should tell you the specific thing it's having trouble finding.

[amitchandak]

@AMBP73 , This happens when one of the column names has changed and is removed from the source. You have to check each step for the error, check from top