Forum Discussion

Andresrsg's avatar
Andresrsg
Frequent Visitor
5 years ago

ODBC - Incremental refresh - Dataflow

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

 

 

Need Help

3 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    5 years ago

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

  • v-angzheng-msft's avatar
    v-angzheng-msft
    Community Support
    4 years ago

    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