PowerBI Refresh issues SharePoint file Error

[shreep1]

Hello PowerBI community,

@Amit, @Greg , @tamerj1 , @lbendlin 

@ HenriqueReis

 @  d_gosbell

@amitchandak , @olgad , @Sahir_Maharaj , @FreemanZ , @tamerj1 , @Greg_Deckler 

My report was based on a SharePoint file rather than a SQL database where data would be updated based on human inputs. 

After sometime, I started getting errors like this: 

Can you please validate that if this is the error due to incorrectly changing column names or file location or something else inside the PowerBI. Or my understanding is wrong and the error is due to some other factors. 

Can you please suggest ways to fix this error so that my PowerBI picks up the new data from the SharePoint file and it starts getting refreshed?

Thanks. 

[audreygerred · Accepted solution]

Usually when I see 'the key didn't match any rows in table' it is indicitive that the table you are trying to query is empty (in this case, Paint Consumption Data). Can you make sure the file/folder/table/worksheet wasn't renamed, moved, deleted, etc.?

[christinepayton · Accepted solution]

This looks to me like the error that happens when your Excel sheet name changes. It tries to find the sheet by name and if someone renames it, it can no longer find it (applies to the filename, sheet name, and table or column names depending on how you connect). 

If you check your file version history, you can verify whether not it changed and update references in the advanced editor.

[audreygerred · Accepted solution]

Usually when I see 'the key didn't match any rows in table' it is indicitive that the table you are trying to query is empty (in this case, Paint Consumption Data). Can you make sure the file/folder/table/worksheet wasn't renamed, moved, deleted, etc.?