MySQL: Fatal error encountered during command execution. error on raw table load

[BIsteht]

I receive this error when trying to refresh my dataset in the Power BI service. A few notes:

1. Data refresh is successful in Power BI Desktop
2. The affected table is a raw table load (no native SQL query with variables, etc.)
3. 6 additional tables in this dataset load from the same data source without issue.

Any thoughts on what could be causing this issue?

[v-lili6-msft]

hi, @BIsteht 

If you could try to upgrade the gateway and try it again.

and what is the error message detail of this error?

Best Regards,

Lin

[BIsteht]

Hi @v-lili6-msft ,

We are using the most recent data gateway (3000.7.149). Please see attached screenshot. The source is Amazon Redshift.

Regards,

Adam

[BIsteht]

Any help here? If I remove the table that is effected in the error below a different table throws the error. So, it seems that it is NOT specific to a particular table.