Forum Discussion
PowerBI Refresh issues SharePoint file Error
- 2 years ago
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.?
- 2 years ago
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.
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.