I am trying to use dataflow on premium capacity to store daily snapshots from an SQL server. Basically, the data required is to get visibility on some ticketing tool backlog (open tickets at the end of the day). The SQL does have a column date, that is the getdate() for when the SQL is running.
I have configured the below incremental refresh in the dataflow. My expectation is to have data for each day when the SQL is running, however, i only have the last day. Can you please help me with some hints on how i should configure this dataflow?