Error while loading files from Sharepoint folder to Lakehouse using the DataFlow Gen2

[vpserefin]

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

---------------

[dsesink01]

Hi @vpserefin

Have you had any updates on this issue?

Thanks

[vpserefin]

I was following the steps from https://blog.enterprisedna.co/power-query-combine-files-from-multiple-folders/#:~:text=For%20this%20....
to connect to a folder on sharepoint and combine all files in a folder.

"Connecting To A Folder In SharePoint or OneDrive"

[Anonymous]

Hi @vpserefin 

Apologies for the issue you have been facing.
Please go ahead and raise a support ticket to reach our support team: Link 

After creating a Support ticket please provide the ticket number as it would help us to track for more information.

Thanks.

[Anonymous]

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