Fabric Pipeline/Dataflow fail to load data into Lakehouse

[tracyng0905]

Hi All.

I am facing a problem on Fabric Pipeline. Anyone has experience on this or can help ? Thanks!

The workspace is already under paid license. 

The lakehouse and pipeline, dataflow are all under same workspace.

Check that the Workspace ID and Lakehouse ID is correct.

but Pipeline copy activity keep failed: 

Regards,

TN

ErrorCode=AdlsGen2OperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=ADLS Gen2 operation failed for: Operation returned an invalid status code 'NotFound'. Account: ''. FileSystem: '2a322f2c-cfaa-47c7-a397-986394fb8099'. Path: '5bf3265c-38c3-4330-af6e-f25d05bb470b/Tables/dbo'. Message: 'Not Found'. TimeStamp: 'Tue, 25 Nov 2025 10:17:03 GMT'..,Source=Microsoft.DataTransfer.ClientLibrary,''Type=Microsoft.Azure.Storage.Data.Models.ErrorSchemaException,Message=Operation returned an invalid status code 'NotFound',Source=Microsoft.DataTransfer.ClientLibrary,'

[v-prasare]

Hi @tracyng0905,

We would like to confirm if our super user answer resolves your query or if you need further help. If you still have any questions or need more support, please feel free to let us know. We are happy to help you.

@Thomaslleblanc, Thanks for your prompt response

Thank you for your patience and look forward to hearing from you.
Best Regards,
Prashanth Are
MS Fabric community support

[Thomaslleblanc]

The error means it cannot find the Account name for the Azure Data Lake Storage Acccount. Verify it exists and the creentials running the pipeline has proper permissions

'Ensure the identity performing the operation has at least "Storage Blob Data Reader" or equivalent permissions on the ADLS Gen2 account and its contents.' 

[Thomaslleblanc]

The error means it cannot find the Account name for the Azure Data Lake Storage Acccount. Verify it exists and the creentials running the pipeline has proper permissions

'Ensure the identity performing the operation has at least "Storage Blob Data Reader" or equivalent permissions on the ADLS Gen2 account and its contents.' 

[tracyng0905]

Hi @Thomaslleblanc ,
Thanks for your reply. My connection is to the Fabric Lakehouse under same workspace as the Fabric Pipeline, It should not need additional permission on ADLS Gen2? 

[v-prasare]

Although the Pipeline and Lakehouse are in the same workspace, the Copy activity still interacts with the underlying OneLake storage. The error occurs because the path under Tables/dbo does not exist or the copy is using an ADLS Gen2 connector instead of the Fabric Lakehouse connector.
Try writing to the Files directory first or re-select the Fabric Lakehouse sink target from the dropdown.

[tracyng0905]

Hi @v-prasare ,
Thanks for your reply. The problem is still here. I tried using File Directory and same error. I tried create a new lakehouse on same tenant still not work. However, exactly same steps in another tenant can work. 

[tracyng0905 · Accepted solution]

Hi @v-prasare , @Thomaslleblanc 
I figure out and fixed the problem. Thanks for your help.

The resolution is that when I use a guest account to create the connection in another Fabric Tenant, I need to sign in to an organization during the auth.