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 ?
This is a SQL Server error, so Tableau is not the problem here. Can you provide some samples of how the date looks when you pull it into Tableau without converting to a date?