ODBC - Incremental refresh - Dataflow

[Andresrsg]

Hi All, 

I'm trying to implement incremental refresh in a dataflow, retrieving data from an  ODBC.

I'm following the steps from Guy in A Cube Link , but found myself stuck with errors in the SQL statement I refer to in my Native query.

They use a Datekey integer, but unfortunately my databse only works with DateTime.
If you can give me a tip it would be much appreciated.

Source = Odbc.Query("dsn=MYConnection", query),

@GuyInACube 

Thank you, 

Andres

[v-angzheng-msft]

hi, @Andresrsg 

May I ask if your problem has been solved? Does the information mentioned above help?

If your problem is solved, we will be glad that you can share your solution here.😀

Best Regards,
Community Support Team _ Zeon Zheng

[jeffshieldsdev]

Shouldn't the date time be wrapped in single quotes?

[lbendlin]

You may want to use Text.Format() rather than DateTime.ToText()