A community member has associated this post with a similar question:
Error Combining SharePoint Files into Lakehouse Table

Only moderators can edit this content.

Error Combining SharePoint Files into Lakehouse Table

Glasier 340 Reputation points
2024-06-19T11:57:42.05+00:00

Hi Team,

I am attempting to combine all files in the SharePoint folder and load them into a fabric lakehouse table. I successfully completed a similar task on another Data Flow, but this one is failing unexpectedly. Can you please assist with this issue? It is blocking our work.

Failure Reason:

An unexpected error occurred while creating your data destination. Please try again later.

Details:

Dataflow ID: a83f0d5f-db7e-49f0-a06e-86369cbc61f4

Query: sp_folder_combine_files

Session ID: b3710704-6736-664a-48d3-18dcf53f4047

Root Activity ID: b3b5717d-4ee9-4994-b361-a84eb7b4bc4b

Time: 2024-06-17T23:05:21.717Z

Additionally, I received the following from Options > Diagnostics:

Session ID: 167b4c56-2580-4db5-8b51-e6f20e0c4975

Thank you for your help.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,923 questions
{count} votes