MySQL: Fatal error encountered during command exec...

BIsteht · ‎08-14-2019

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

Data refresh is successful in Power BI Desktop
The affected table is a raw table load (no native SQL query with variables, etc.)
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 · ‎08-15-2019

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

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

BIsteht · ‎08-15-2019

Hi @v-lili6-msft ,

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

PBI service refresh error.png

Regards,

Adam

BIsteht · ‎08-20-2019

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.