Forum Discussion

cham's avatar
cham
Post Patron
7 years ago

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 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

General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

3 Replies

  • Stachu's avatar
    Stachu
    Community Champion
    7 years ago

    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's avatar
      cham
      Post Patron
      7 years ago

      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.

  • v-frfei-msft's avatar
    v-frfei-msft
    Community Support
    7 years ago

    Hi cham ,

     

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