Forum Discussion

BIsteht's avatar
BIsteht
Helper III
7 years ago

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

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?

Need Help

3 Replies

  • v-lili6-msft's avatar
    v-lili6-msft
    Community Support
    7 years ago

    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's avatar
      BIsteht
      Helper III
      7 years ago

      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's avatar
        BIsteht
        Helper III
        7 years ago

        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.