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

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

vpserefin — Tue, 18 Jun 2024 13:14:09 GMT

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

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

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

Anonymous — Wed, 19 Jun 2024 12:27:20 GMT

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

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

vpserefin — Fri, 21 Jun 2024 14:15:58 GMT

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"

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

Anonymous — Fri, 05 Jul 2024 04:41:26 GMT

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.

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

dsesink01 — Thu, 01 Aug 2024 14:25:16 GMT

Hi vpserefin

Have you had any updates on this issue?

Thanks