Expression.Error: The key didn't match any rows in the table.

[Frasermc98]

Hello, 

I am getting the following error when refreshing a table on my dashboard:

Expression.Error: The key didn't match any rows in the table.
Details:
Key=
Name=RSI ForceDecks Input.xlsx
Table=[Table]

The table refreshed fine yesterday. Today it failed to refresh and so I removed any excel sheets that had been added to the sharepoint folder and the same error message is still appearing. The names of all excel files have stayed the same in the folder as well as the names of the sheets which the data is contained in. I am therefore unsure what the error could be as all notice boards have suggested a change in the name of a sheet. Any help someone can provide me with would be greatly apppreciated. 

[Dhairya · Accepted solution]

Hey @Frasermc98
 
This type of error occurs in the following conditions
- Data source is renamed or deleted
- Sheet or Column name has been changed or deleted

To solve this type of error you should navigate back to the source and check every transformation step you will be able to find where the exact error persists and make sure the name of the source table, sheet, and column names.

Please mark my solution as accepted if it helps you!