Forum Discussion
Error while refreshing dataflow gen2
- 10 months ago
Hi Shubham_rai955 ,
Thanks for reaching out to the Microsoft fabric community forum.This issue can be caused by a data type mismatch where Date/Time is the required data type for the RangeStart and RangeEnd parameters, but the table date column on which the filters are applied aren't Date/Time data type, or vice-versa. Both the parameters data type and the filtered data column must be Date/Time data type and the format must be the same. If not, the query can't be folded.
Solution: Verify data type
Verify the date/time column for the incremental refresh table is of Date/Time data type. If your table doesn't contain a column of Date/Time data type, but instead uses an integer data type, you can create a function that converts the date/time value in the RangeStart and RangeEnd parameters to match the integer surrogate key of the data source table.Additionally cast the column to integer if it is incorrectly specified in dataflow as mentioned by vivien57
I hope this information helps. Please do let us know if you have any further queries.
Thank you
This forum will be more suitable for your error :
https://community.fabric.microsoft.com/t5/Dataflow/bd-p/df_dataflows