Forum Discussion
SnoekL
Helper II
Helper IIDataFlow Gen2 issue We couldn't convert to Date.
I'm loading data from a on-premise Gupta database using ODBC with DataFlow Gen2 It's working fine until I try to make it an incremental refresh using the last date from the already loaded table. ...
The VW_INCR_DATE value is coming from the warehouse and is the last date for which the data is already loaded. That is not from the source.
I found the solution. The query which extracts the Date value from the warehouse should have "enable staging" false to get it working. Not sure why though :).
aj1973
Community Champion
Community ChampionWhen connecting to ODBC
Add a SQL statement to convert/cast this part
to Date before loading into Power Query Online.
Power Query couldn't accept to add a step to Format that column so try with SQL statement, it should work.
SnoekLHelper II
Helper IIThe VW_INCR_DATE value is coming from the warehouse and is the last date for which the data is already loaded. That is not from the source.