Dataflow Deployment

Hope someone can help with this.

I have a pipline that runs successfully in the first work space then I deploy it to the second workspace.

I then run the refresh on one of the data flows that inturn triggers refreshes were the dataflow is linked to others and it fails but if I run the same one in the first workspace that I deployed from it works.

So far I have gone into each dataflow in the second workspace and updated the connection details and it previews the data when editing.

The error shows its missing a column, I've traced it back to a pivot table so the only thing I can think of its updating in the wrong order.

This is confusing because it works in the first work space.

Any suggestions greatly appreciated.

Chris