Dataflow Gen2 Non-Specific Errors

[FabricUser86]

Hello,

I was wondering if anyone would be able to help me with the below errors. I have a dataflow gen2 trying to use the export to sharepoint function via a CSV file. The queries inside the dataflow work correctly but when trying to save and run I get the following two errors:

There was a problem refreshing the dataflow: 'Something went wrong, please try again later. If the error persists, please contact support.'. Error code: 104500. (Request ID: 009612d0-3d03-48a5-895d-8bf6b6479d19).

(nameofdataflow)_WriteToDataDestination: There was a problem refreshing the dataflow: 'Something went wrong, please try again later. If the error persists, please contact support.'. Error code: 999999. (Request ID: 009612d0-3d03-48a5-895d-8bf6b6479d19).

[v-echaithra]

Hi @FabricUser86 ,

May I ask if you have resolved this issue? Please let us know if you have any further issues, we are happy to help.

Thank you.

[FabricUser86 · Accepted solution]

Sorry for the delay in response, I was on annual leave. It seemed to be "Fast Write" on the individual query that was carrying out the export that was causing the issue. When this was disabled the error finally cleared and it exported as expected.
I had been through every column and checked all data types both in source and destination and there was no incompatabilities there (and it was a very small data set so limited scope for error)

[v-echaithra]

Hi @FabricUser86 ,

Thank you @pallavi_r  for your response.

I hope the information provided is helpful.I wanted to check whether you were able to resolve the issue with the provided solutions.Please let us know if you need any further assistance.

Thank you.

[pallavi_r]

Hi @FabricUser86 

I also get these error very often related to mashup. Then I try checking column types are properly mapped for destination with appropriate data type especially the date fields, no invalid character in column name or data that should be handled otherwise. And at times adding a new table in the lakehouse with changed column format and chosen column for ingestion works.

Thanks,

Pallavi

[v-echaithra]

Hi @FabricUser86 ,

Thank you  @Anusha66  for your inputs.

We’d like to follow up regarding the recent concern. Kindly confirm whether the issue has been resolved, or if further assistance is still required. We are available to support you and are committed to helping you reach a resolution.

Thank you for your patience and look forward to hearing from you.

Best Regards,
Chaithra E.

[Anusha66]

These errors are usually due to  Generic refresh failure and Write-to-destination failure which relate to mashup issues, invalid configurations, or preview limitations.
I'd suggest you make sure your SharePoint folder exists, names are clean (no weird symbols or slashes), and the site’s connected properly. Preview your queries to confirm flat tables and not something messy. Keep data types simple, connections fresh, and run a manual refresh. Also suggest you to check in Fabrid docs if the features you are using are in Preview. 

The below could be a useful link -https://blog.fabric.microsoft.com/en-us/blog/sharepoint-files-destination-the-first-file-based-desti...