topic Re: Fabric Pipeline/Dataflow fail to load data into Lakehouse in Pipelines

Fabric Pipeline/Dataflow fail to load data into Lakehouse

tracyng0905 — Tue, 25 Nov 2025 10:33:12 GMT

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,'

Re: Fabric Pipeline/Dataflow fail to load data into Lakehouse

Thomaslleblanc — Tue, 25 Nov 2025 20:19:14 GMT

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.'

Re: Fabric Pipeline/Dataflow fail to load data into Lakehouse

Thomaslleblanc — Tue, 25 Nov 2025 20:22:05 GMT

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.'

Re: Fabric Pipeline/Dataflow fail to load data into Lakehouse

tracyng0905 — Thu, 27 Nov 2025 03:10:38 GMT

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?

Re: Fabric Pipeline/Dataflow fail to load data into Lakehouse

v-prasare — Tue, 02 Dec 2025 12:08:37 GMT

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.

Re: Fabric Pipeline/Dataflow fail to load data into Lakehouse

v-prasare — Mon, 08 Dec 2025 10:55:33 GMT

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

Re: Fabric Pipeline/Dataflow fail to load data into Lakehouse

tracyng0905 — Tue, 09 Dec 2025 04:11:58 GMT

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.

Re: Fabric Pipeline/Dataflow fail to load data into Lakehouse

tracyng0905 — Tue, 09 Dec 2025 10:27:44 GMT

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.