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
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 

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},
...