DataFlow Gen2 - Errors while publishing details to warehouse

Hi DRSH_9876 ,

Thanks for getting back and for sharing the detailed screenshots of your Dataflow and the error logs.

Regarding the missing Publish button, in Dataflow Gen2 with CI/CD enabled (Git integration), the Publish option is replaced by Save and Run. It looks like this setting was enabled when you created the Dataflow, which is why you’re seeing the Save and Run button instead.

As for the error you’re encountering, it’s challenging to pinpoint the root cause based on the screenshots alone. Since you’ve mentioned facing a similar error during the Copy Data activity in your pipelines, this suggests the issue might be originating from the data source itself - possibly related to the CSV file formatting or structure.

Please verify the consistency of the CSV files, especially the second line where the error occurs, to ensure the columns align with the header and data format expectations.

If the issue persists or requires more detailed troubleshooting, raising a support ticket with Microsoft Fabric support would be the best option to get dedicated help:
https://support.fabric.microsoft.com/support

If you have already raised a support ticket, please feel free to share any insights or solutions provided by the support team here. This would greatly help others in the community who might be facing similar issues.

Best Regards,
Vinay,
Fabric Community Support.