Forum Discussion
Refresh Failed
A major report in our company is failing to refresh. So,when I refresh the dataset I got "The key didn't match any rows in the table" error. I tried to see if there was any specific column and there was nothing. Any help
4 Replies
- themistoklisCommunity Champion
Anonymous
A very typical example is when you are trying to connect to a sheet that doesnt exist in the spreadsheet anymore
Maybe this link will help:
- vanessafvgCommunity Champion
how many columns do you have? have you tried removing them one by one to see where the problem might be?
- AnonymousNot applicable
I have more than 160 columns and more than 5 tables. It's gonna take me so much time.
- v-janeyg-msftCommunity Support
Hi, Anonymous
Can you refresh normally in the desktop? Does the error only exist in the service? What data source and connection mode are you using?
You can try to refresh the data source or reconnect to the data source and configure credentials on the desktop.