Forum Discussion
Dataflow Gen2 Unable to Write
Hello All, I've been unable to get dataflows to work in two different workspaces. I am trying to load data from Salesforce objects to Fabric. Here are the errors I am recieving. It seems like my ...
Gen2 Dataflows are still not usable in a production environment as they still have a lot of issues on the load side of their operation.
We are actively engaged with Microsoft Engineers playing whack-a mole and in fairness a lot of progress has been made.
In the mean time we have adopted the follwing solution
1: Load to staging datamart
2: Create a data pipeline that first executes a delete stored procedure on target table in warehouse, then loads data from datamart to datawarehouse using a copy data operation
it is a bit of a faff to setup but once built works well with no intermittent failures that can be exeperienced with Gen2 Dataflows