Schedule refresh error

[cham]

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 unable to convert the value '' from the source data type 'VT_BSTR' to the expected data type 'VT_I8'. Please check the column data types in the data model and data source and ensure that the data types are compatible.

Regards,

cham

[v-frfei-msft]

Hi @cham ,

How about deleting the dataset and republish the report to check again?

[Stachu]

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

[cham]

Hi @Stachu 

That filed is in text format. I replaced " with null. But it didnt work.

But I'm getting the errors in other field not the filed that mentioned in the shedule refresh error.