topic Re: DataflowGen2 fails to publish to Synapse Warehouse in Data Warehouse

DataflowGen2 fails to publish to Synapse Warehouse

meandme — Thu, 19 Sep 2024 08:27:26 GMT

Hi, I am trying to publish a table from dataflow gen 2 to synapse warehouse in fabric. However , I get the following error:

I changed my column types to either text or wholenumber to comply with datatypes that the warehouse supports, I have tried removing special characters in my rows but I still run into the same problem, please send helpful tips and advice

Re: DataflowGen2 fails to publish to Synapse Warehouse

Anonymous — Fri, 20 Sep 2024 01:45:48 GMT

HI meandme ,

As the error message mentions, current some of data type currently not supported in data warehouse. What data type are you used ot define the table columns in the dataflow?
You can take a look at the following document to know more about these:

Data types - Microsoft Fabric | Microsoft Learn

BTW, current there are some known issues about dataflow gen2 usages, you can also check them on the support page if they meet to your scenario:

Microsoft Fabric Known Issues

Regards,

Xiaoxin Sheng

Re: DataflowGen2 fails to publish to Synapse Warehouse

Anonymous — Wed, 25 Sep 2024 05:16:12 GMT

Hi meandme ,

Any update on this? Can you please share some more detail information about this issue? They should help us clarify your scenario and test to troubleshoot.

How to Get Your Question Answered Quickly

Regards,

Xiaoxin Sheng