Forum Discussion
Dataflow Gen2 Non-Specific Errors
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)
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-destination-for-dataflows-gen2/