Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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),
Thank you,
Andres
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
Shouldn't the date time be wrapped in single quotes?
You may want to use Text.Format() rather than DateTime.ToText()
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.