Data Type Issue in fabric dataware house

Hi onenessboy 

The error you're seeing occurs because SQL Data Warehouse (Synapse) doesn't support nvarchar(max) in the same way as Azure SQL Database.

The solution is to:

Adjust Column Types: Change the column in the destination Data Warehouse to nvarchar(4000) or another fixed size to match the data.

Truncate Data: Use LEFT() to limit the size of the nvarchar(max) data before transferring it.

Disable ANSI_WARNINGS: Try turning off ANSI_WARNINGS in SQL to allow truncation, but this may hide errors.

Check Data Mapping: Ensure source and destination columns are compatible in size and type.

Use Dataflows: Use Fabric Dataflows or Pipelines to preprocess the data if needed.

These steps should help resolve the issue with large data being truncated.

Did I answer your question? Mark my post as a solution, this will help others!

If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂

Kind Regards,
Poojara
Data Analyst | MSBI Developer | Power BI Consultant
Consider Subscribing my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS