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.

anilelmastasi's avatar
anilelmastasi
Super User
1 year ago

Hello Anonymous ,

 

The error you're facing while refreshing your Date table from Dataflow Gen2 to Microsoft Fabric Warehouse is likely due to a data type mismatch between the column in your dataflow (source) and the corresponding column in the destination Fabric WH table.

 

Check the column type in Dataflow Gen2:

Open the Power Query editor for your dataflow.

Look at the data type of the 'Date' column.

Ensure it is explicitly set as date (not datetime or text).

 

Check the target table schema in Fabric WH:

Go to Fabric WH and inspect the schema of the destination table.

Make sure the 'Date' column is of the same type as in your dataflow (date if that’s what you defined).

 

Update column types to match:

If the Dataflow column is datetime but the WH expects date, apply a transformation in Power Query:

Table.TransformColumnTypes(#"Previous Step", {{"Date", type date}})

 

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