Forum Discussion

lucasgalde's avatar
lucasgalde
Regular Visitor
1 year ago
Solved

Error Loading Data from Dataflow Gen2 to Microsoft Fabric Data Warehouse

I am experiencing an issue with all my Dataflows Gen2 in Microsoft Fabric. The process loads the data successfully but fails to transfer it to the Fabric Data Warehouse. The error message received is...
data warehouse
  • v-nmadadi-msft's avatar
    v-nmadadi-msft
    1 year ago

    Hi lucasgalde ,

    Please chcek if these two scenarios are inadvertently causing the error:

    The error message suggests a data type mismatch between your pre and post refresh data. For example, a column that previously contained datetime values is now containing only date values which may inadvertently cause the error.

    Another possible reason for the issue, as you mentioned not encountering the error in Azure SQL Database and Lakehouse, could be that the data includes a datatype that is unsupported by Fabric Warehouse.
    Document to check what data types are not supported by Warehouse:
    Data types - Microsoft Fabric | Microsoft Learn


    If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS.
    Thanks and Regards

v-nmadadi-msft's avatar
v-nmadadi-msft
Community Support
1 year ago

Hi lucasgalde,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.