Forum Discussion
The key didn't match any rows in the table - SQL DB
Many thanks for your reply. But I have found the issue. It appeared to be in the permissions in data source settings. After clearing the permissions and providing them again in "edit permissions..." the refresh worked without error.
Sometime back I had a similar issue.
I resolved it by first creating the table structure in the SQL server. Then instead of importing the .csv file into the server, I instead appended it to the table I had created in the server. Then, if the same structure is needed for another .csv file with the same structure, I simply copied the structure I had created in the SQL table to another new table and appended the new .csv file to that new table ... but a better solution might be to simply add a field that differentiates the newly appended data from the data currently in the table. For example the field could be named: Date_Appended or Appended_File_Name, etc.
I hope it helps.
Good Luck 🙂
Many thanks for your reply. But I have found the issue. It appeared to be in the permissions in data source settings. After clearing the permissions and providing them again in "edit permissions..." the refresh worked without error.