Forum Discussion

jcaubin's avatar
jcaubin
Frequent Visitor
2 years ago

Dataflow gen2 to lakehouse table type error

A dataflow gen 2, last step, conver column type to date.

Dataflow run ends with error cant insert dateTime into date


Last df step: 

  #"Tipo de columna cambiado" = Table.TransformColumnTypes(#"Remove Columns", {{"FEC_MATRICULA", type date}, {"FEC_TRAMITACION", type date}, {"FEC_TRAMITE", type date}, {"FEC_PRIM_MATRICULACION", type date}, {"FEC_PROCESO", type date}})

 

Dataflow run error:

Mashup Exception Data Format Error Couldn't refresh the entity because of an issue with the mashup document MashupException.Error: DataFormat.Error: We can't insert values of type 'DateTime' into column 'FEC_MATRICULA' because it expects values of type 'Date'. Details:  

Dataflows

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi jcaubin ,

    I have tried to reproduce the scenario. Uploaded a sample excel file in Lakehouse using Data Flow Gen2. 

    Input Excel Sheet:


    Data Flow Gen2 ( modified_date_1: DateTime to Date, modified_date_time_2: DateTime to DateTime)

     


    DataFlow Gen2 Executed without any errors -
    In SQL Endpoint:


    In Notebook:


    For helping you better can you please send the screenshots of how you are trying to work with DataFlow Gen2 and the steps which you followed. 
    Hope this helps. Do lets us know if you have any further queries.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hello jcaubin ,
      We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .
      In case if you have any resolution please do share that same with the community as it can be helpful to others .
      Otherwise, will respond back with the more details and we will try to help .

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hello jcaubin ,
        We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .
        In case if you have any resolution please do share that same with the community as it can be helpful to others .
        If you have any question relating to the current thread, please do let us know and we will try out best to help you.
        In case if you have any other question on a different issue, we request you to open a new thread .

  • jcaubin's avatar
    jcaubin
    Frequent Visitor
    2 years ago

    Sorry. As soon as I can prep a simple test case i will post it.

  • Shikha_Solanki's avatar
    Shikha_Solanki
    Frequent Visitor
    1 year ago

    I have same issue please help to resolve the issue 
    Datatype is same in both place lakehouse Table and Gen2 data flow 
     We can't insert values of type 'DateTime' into column 'Date' because it expects values of type 'Date

    what should i do in that case