Forum Discussion
Operation returned an invalid status code 'Unauthorized' while copying data to Lakehouse
ErrorCode=LakehouseOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Lakehouse operation failed for: Operation returned an invalid status code 'Unauthorized'....
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.
I am afraid there is no doc on “refreshing token using pipeline” because fabric does not support it. Oauth tokens for lakehouse conne are user based and expire silently during long running copy operations.