odbc dataflow refresh issues

[Freedom]

Hi,

I have created datflow via odbc connection with custom sql. All data shows fine in editor without any issues. When I try to refresh it manually or via scheduler, following error appears.

Error: ODBC: ERROR [22018] [MySQL][ODBC 8.0(a) Driver][mysqld-5.7.12-log] Request ID: de0e4ece-3fbe-a353-6406-67b066ce6e49 Activity ID: 5a6fc174-71aa-4ac9-be51-448d69e7fa18

This seems to work if I have only 1 column or less than 100 rows. Seems like a bug as after about 30-50 seconds, it times out.

Hope you can assist in providing more details about this error.

Thanks

[v-chuncz-msft]

@Freedom 

You may check if Understanding and optimizing dataflow refresh helps.