Fabric Data Warehouse

Hi HR_GN ,

I have tested it and when I select the “Enable staging” option it does not reproduce your error, it works fine. When I do not select the “Enable staging” option I can reproduce your error.

I have seen other users experiencing similar issues:

Difficulties with data from Lakehouse to Warehouse... - Microsoft Fabric Community

The reason for this issue is that some sources do not support the direct copy command, which requires staging. However, the performance message suggests disabling staging for better performance, leading to the conflicting messages you see.

You can try some workarounds:

• You can use Dataflow Gen2 in Fabric to move data from Lakehouse to Warehouse.
• You can use it by selecting the SQL endpoint corresponding to lakehouse at Explorer of Warehouse.

If you have any other questions please feel free to contact me.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!