Forum Discussion
Error while loading files from Sharepoint folder to Lakehouse using the DataFlow Gen2
Hi Team,
I am trying to combine all files in the Sharepoint Folder and load it into a lakehouse table. I had done something similar on another Data Flow and it works fine. However, this one fails for unexpected reason. Can you please help with this issue. It is blocking our work.
Failure reason:
Unexpected error occurred while creating your data destination. Please try again later.
Please try again later.
Dataflow ID: a83f0d5f-db7e-49f0-a06e-86369cbc61f4
Details: 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
----------------
I also got the following from Options > Diagnostics
Session ID: 167b4c56-2580-4db5-8b51-e6f20e0c4975
---------------
4 Replies
Hi vpserefin
Thanks for using Fabric Community.
Can you please provide the repro steps here? This way I would understand the issue better and can help.
Thanks
I was following the steps from https://blog.enterprisedna.co/power-query-combine-files-from-multiple-folders/#:~:text=For%20this%20one%2C%20all%20we,helper%20queries%20were%20also%20created.
to connect to a folder on sharepoint and combine all files in a folder."Connecting To A Folder In SharePoint or OneDrive"
