2 Replies Latest reply on Jul 21, 2018 11:40 AM by Ken Flerlage

    Extract refresh fail because of date time conversion error

    arun.yadav

      Hi All,

       

      I am connecting to SQL Server PDW. The remote columns are defined as Datetime in sql warehouse. But Tableau is pulling them as string field and if I'm trying to convert this string field into date time field, it's giving error while refreshing the extract.

      [Microsoft][SQL Server Native Client 11.0][SQL Server]Conversion failed when converting date and/or time from character string.

      Unable to create extract

       

      It seems to be generic issue. Has anyone figured out any solution for this ?

       

      Regards,

      Arun