Operation returned an invalid status code 'Unauthorized' while copying data to Lakehouse

Vinodh247 Thanks for replying.

I'm trying the workarounds that you suggested

1. The connection still seems to be mandatory. Even when the Lakehouse is attached directly, Fabric asks for a connection to be created.

2. This approach works for small tables that run in a loop(can you please provide some info or document on how to refresh token using pipeline), but for large-volume tables the token expires in the middle of the extraction. We are planning to load these tables in chunks based on the date fields to avoid the issue.