Andrew on 01 Aug 2018 23:44:36
Incremental Refresh appears to only function for inserting the parameters into a Date/Time format.
What about where users are using DirectQuery, which does not allow us to change the format type of a column, and the SQL Server data being queried is only in Date format, not Date/Time?
Please allow parameters and incremental refresh to function as well for Date format columns.
- Comments (1)
RE: incremental refresh for date not just date/time
As I was testing some more, am I wrong to think Incremental Refresh can be applied to DirectQuery? It is strictly limited to Import? What about Dual within the new Composite Model release though?