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

This seems like a fabric platform issue and fabric regression, not your config. Microsoft recently changed the Lakehouse destination to require a Lakehouse connection, and that connection now uses OAuth only. Pipelines cannot refresh oauth tokens, so once your user token expires, the copy activity fails with Unauthorized when writing to OneLake. It is not related to SAP hana/permissions.

Workarounds that you can try:

1. Avoid using the new Lakehouse connection (use manual table entry if still available).

2. Recreate the conn before each run (temp).

3. Raise a support ticket because the change broke non interactive pipeline loads.