I am testing out fabric for my organization and one of our key things to figure out is how to attached to a vendors MySQL database on AWS and bring it back to a LakeHouse. I have created a Gen2 Dataflow that uses our on prem Data Gateway. I then provide it the login info for the MySQL database on AWS and I can succefully see all the table in the database, so that part seems succeful. However when I attempt to bring it back to the LakeHouse in Fabric it fails. Error messages can be seen below.

There was a problem refreshing the dataflow. Please review the error message(s) below, fix the problem, and try again. (Request ID: ee843b8f-21f2-4a4b-a0ee-9ad495a060b6)
flightspan_maf_test aircraft: Error Code: 999999, Error Details: Couldn't refresh the entity because of an issue with the mashup document MashupException.Error: Unable to load DLL 'ParquetSharpNative': A dynamic link library (DLL) initialization routine failed. (Exception from HRESULT: 0x8007045A) Details: GatewayObjectId: 6b63dd19-d7ee-4ee0-8a3a-0bb4e48f5b66 (Request ID: ee843b8f-21f2-4a4b-a0ee-9ad495a060b6).

After the process runs, I do seem to get a empty parquet file and a _delta_log file in the Tables section of the LakeHouse. All the files have a size of 0.

To rectify the situation we have attempted several things:

1) Per a form post we have upgraded to the latest version of the Data Gateway - no luck

2) I have stripped the fields moved over to the DataLake to just two fields - no luck

3) Turned off Enable Staging on the table

Any ideas?

Thanks for your Help

Frank

Forum Discussion