Forum Discussion
Dataflow Gen2 Error message: Unexpected error occurred while creating your data destination
Hi JK_CM
Thanks for confirming it's a REST API. Since Gen1 works fine, the issue is likely with how Gen2 handles writing to the Lakehouse or Warehouse.
A few quick things to check.
- Make sure all column names are clean (no special characters or duplicates).
- Try manually setting data types instead of relying on auto-detection.
- Test writing to a brand new Lakehouse or Warehouse to rule out schema conflicts.
- Also try switching between append and replace as the load method.
Gen2 can be a bit sensitive with schema mapping, especially during write operations.
Let us know if any of these help.
____________________________________________________________________________________________________________________________
If the response helped resolve your issue, please consider marking it as Accepted as Solution and give it a thumbs up if you found it helpful.
Best regards,
Akhil.
I've tried this with a single table containing 9 rows and three text columns and am still getting the same error. I've switched to a notebook, which seems to work. It's very unfortunate, because I really like working with dataflows.
