Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

DataflowGen2 in Fabric refresh issue

Hi All ,    I am facing issue in Date table. I created Date table in DataflowGen2 with some logics and I want to give its destination to Fabric WH. I also have other tables which have source and d...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Thanks all who gave responses .
    I got solution for this . 
    Steps I followed 
    1.First I changed data type in Dataflow from Date to DateTime 
    2.I also changed structure of table in Warehouse . initially it was Date , I changed to DateTime(6)

    Then published dataflow gen 2 . error gone and data stored from Dataflow to WH 

    Thanks and regards 
    Shiva.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Thanks anilelmastasi 

Intitially only I observed it . In dataflow gen2 Date format is "MM-DD-YYYY" , In WH format is "YYYY-MM-DD".
1.if I consider this is route cause how come it refreshed yesterday ? 

2. I also try to change the date fomrat in Dataflow gen 2 seems not having option where can i find it (Need transormation in existing column only) ? 

  • anilelmastasi's avatar
    anilelmastasi
    Super User
    1 year ago

    You are welcome Anonymous ,

     

    1.Even if the date format appears as MM-DD-YYYY in Dataflow Gen2 and YYYY-MM-DD in WH, what truly matters is the underlying data type, not the visual format.

    It might have worked yesterday because:

    The data values didn't trigger any parsing issues (e.g., 04-28-2025 could be read)

    But now:

    New data values might have ambiguous dates (e.g., 13-04-2025, which is invalid in MM-DD-YYYY), leading to failure.

     

    2. Dataflow Gen2 does not let you directly change "format" like MM-DD-YYYY vs YYYY-MM-DD — that’s only how it’s shown.

    What you must ensure is that the column is of proper date data type, not text.

     

    If this solved your issue, please mark it as the accepted solution. ✅