Forum Discussion
cham
7 years agoPost Patron
Schedule refresh error
Hi, Im getting below error when i create the shedule refresh. How can I fix that? Unable to convert a value to the data type requested for table 'Sheet1' column 'ID'. The data provider was unabl...
Stachu
7 years agoCommunity Champion
with this error manual refresh should also fail, is that the case?
it seems that in the Excel you're connecting to you have a text value, I guess you convert to number?
you could replace the '' with null/0 and see if that works