Forum Discussion
Error Loading Data from Dataflow Gen2 to Microsoft Fabric Data Warehouse
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
Hi v-nmadadi-msft,
Thank you for your response!
In my case, my Gen2 is connected to a Fabric Data Warehouse, where enabling the staging option is mandatory. Because of this, I am unable to disable it to test this solution.
Best regards
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