I have a standard table on an Azure SQL database that I want to turn on incremental refresh on.
The problem is that I keep getting the "query folding" warning, and if I run the incremental refresh anyway it is painfully slow.
The table is just being loaded as is and contains a DateTime column like required in the MS guide.
The only thing I can think of being the cause of the query being non-foldable is the fact that the DateTime column also contains milliseconds.
Does anyone know if the DateTime format strictly has to be 'YYYY-MM-DD-HH-MM-SS' for query folding and therefore incremental refresh to work in Power BI? Maybe there is even a preferred T-SQL DateTime format like 120 etc?