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