Error while refreshing dataflow gen2

[Shubham_rai955]

Facing this issue while refreshing the dataflow, Implemented incremental refresh, and not doing any transformaition using M query in any table. Please guide me how to resolve this.

[v-nmadadi-msft]

Hi @Shubham_rai955 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Thank you.

[v-nmadadi-msft · Accepted solution]

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

[vivien57]

This forum will be more suitable for your error :

https://community.fabric.microsoft.com/t5/Dataflow/bd-p/df_dataflows

[vivien57]

Hello @Shubham_rai955 ,

In your DataflowGen2, did you specify an explicit cast to Number for this column?

Are you getting errors for the values ​​in this column in the Dataflow development screen?

Don't hesitate to give a kudo if my answer helps you.

Have a nice day,

Vivien

[Shubham_rai955]

I am not doing any transformation in the dataflow, I am not getting error in dataflow page,, only getiting error while refreshing manually and schduled

[vivien57]

In this case, can you perform a type transformation for this column in the DataFlow?

Cast it to an integer and see what happens 😉

Don't hesitate to give a kudo if my answer helps you.

Vivien