Dataflow incremental refresh

[J4ns3n]

Hi All,

I created a dataflow where I want to use incremental refresh. After deploying the incremental refresh (which is set to store last 13 months and refresh last month) it only stores data of this year. 2022 data is not available anymore in the dataflow. 

The datetime column is based on reportingmonth which is yyyymm. This integer colum is transformed to datetime via the following SQL statement: CONVERT(DATETIME,CONCAT('1-',right([ReportingMonth],2),'-',LEFT([ReportingMonth],4)),102)

Any ideas why only data from 2023 is loaded? 
@ToddChitt @Greg_Deckler