Forum Discussion

Janica123's avatar
Janica123
Helper I
2 years ago

Dataflow Gen2 Mashup Error: Loading Data into Lakehouse

Hi all,    I'm currently doing this fabric tutorial on youtube (https://www.youtube.com/watch?v=HLVkIsZvgzE). Uploading the parquet files into the Lakehouse was no problem. Then one needs to conve...
Dataflows
Need Help
miguel's avatar
miguel
Community Admin
2 years ago

Can you go back to the Data Destination settings and show a screenshot of the column and data types mappings that show in there for the table?

  • Janica123's avatar
    Janica123
    Helper I
    2 years ago

    Thanks for your reply! 
    Here a screenshot of the column and data types mappings for the table 

     

    Remark: The columns in my source originally have spaces. In the Data Destination settings Fabric automatically suggest me to fix this, since they are not allowed in destination. Thats reason for the information on the top 

    • miguel's avatar
      miguel
      Community Admin
      2 years ago

      go to the workspace list view, find the dataflow, click the 3 dots and get the ".json" file for the dataflow. In there you can check the Mashup script and see if there's any reference made to a datetime - that could be causing the issue.

      • v-cboorla-msft's avatar
        v-cboorla-msft
        Microsoft Employee
        2 years ago

        Hi Janica123 

         

        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.


        Thanks.

    • Element115's avatar
      Element115
      Memorable Member
      2 years ago

      This is strange.. I remember having the same issue once and I fixed it by opening the Advanced Editor and adding  {"DATE", type date}  to the params list of function Table.TransformColumnTypes() like so:

       

       

        #"Changed column type"  = Table.TransformColumnTypes(
                                                        dbo_RWS_15M, 
                                                        {
                                                          {"DATE", type date},
...