Error trying to do an incremental refresh with DateTime data type

So what I do is sort descending the date column

Sorting operations in Power Query are very likely to break folding. Avoid at all cost.

Incremental Refresh in Dataflows is fully automated. You are not allowed to provide your own filter statement. All you can do is indicate the datetime column that should be used.  The Power BI service then adds the required M code at the end (!!!) .

Using incremental refresh with dataflows - Power Query | Microsoft Learn