MySQL: Fatal error encountered during data read - PowerBI

[RanHo]

Good day! 

Anyone had an idea how would it be solved? 
Any advice and solution might help.

Rows estimated 57k
FileSize estimated 140mb

Underlying error code: -2147467259
Underlying error message: MySQL: Fatal error encountered during data read.
DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
Microsoft.Data.Mashup.ValueError.DataSourceKind: MySql
Microsoft.Data.Mashup.ValueError.DataSourcePath: 103.19.16.121;gpisclou_ecpdb
Microsoft.Data.Mashup.ValueError.ErrorCode: -2147467259
Microsoft.Data.Mashup.ValueError.Message: Fatal error encountered during data read.
Microsoft.Data.Mashup.ValueError.Reason: DataSource.Error
Cluster URI: WABI-SOUTH-EAST-ASIA-B-PRIMARY-redirect.analysis.windows.net
Activity ID: a6d70213-9f8d-4a87-a3fa-b73887745c98
Request ID: 32782788-677d-4ba2-acbb-470e6336bb49
Time: 2022-07-29 00:13:29Z


Thanks in advance.

[v-easonf-msft]

Hi, @RanHo 

Make sure the current account can access data on MySql successfully and check if it have something to do with query timeouts.

Best Regards,
Community Support Team _ Eason

[amitchandak]

@RanHo , Two different user faced different issues

https://community.powerbi.com/t5/Desktop/OLE-DB-or-ODBC-error-DataSource-Error-MySQL-Fatal-error/m-p...

https://community.powerbi.com/t5/Desktop/MySQL-Fatal-error-encountered-during-command-execution/m-p/...

[RanHo]

@amitchandak  i already check the two scenario but still the same, then i decided to make a new report wherein I try load the table that has a fewer rows and it work without error . after I tried again the table that has a bigger data then it show an error, this error:
  Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] MySQL: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding..

Does that mean the bigger data table causing the problem and error?
Any advice ? Thanks 
'.

[JayantaPaul97]

Hi @RanHo, There maybe two reason.

1) MySQL query timeout,

First, which you need to set from your database software (lets you are using MySQL Workbeach), then goto Edit-> Preference-> MySQL Editor-> MySQL Session, and change the below setting .

Second, You need to change in Power BI Server goto Admin Portal->Capacity Setting->Workload

2) Database permission releted issue: Clearing all data source permissions (File-->Options and Settings --> Data Source Settings --> clear each data source permission).