Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

kevinkangdinata

Power Bi Service - Scheduled Refresh Failed On Datasource MySQL

Submitted by on ‎09-22-2020 02:05 AM

Dear Supportive Power BI Users & Admin ,

 

My Scheduled Refresh failed and error message as shown below occur. Can Somebody help me? 

 

I have no problem refreshing in desktop. Data gateway is running well too.

 

 

Something went wrong
There was an error when processing the data in the dataset.
Please try again later or contact support. If you contact support, please provide these details.
Data source error: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"MySQL: Fatal error encountered during data read."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"MySql"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"10.2.2.13;loket_pos"}},{"code":"Microsoft.Data.Mashup.ValueError.ErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Message","detail":{"type":1,"value":"Fatal error encountered during data read."}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}}
Cluster URI: WABI-SOUTH-EAST-ASIA-B-PRIMARY-redirect.analysis.windows.net
Activity ID: f3220264-42f9-42b0-ad67-fbca6e603ae5
Request ID: 04f58be4-e9f0-47b7-b711-a484436e6784
Time: 2020-09-22 08:35:56Z

Status: New
See more ideas labeled with:
2 Comments (2 New)
Comments
v-yuta-msft
Community Support
Community Support
‎09-22-2020 08:07 PM

@kevinkangdinata ,

 

Please check if the credentials are all vaild and necessary ports have been enabled for mysql server on your machine. Also make sure data gateway has been updated to the latest version. In addtion, if this issue still persists, please provide more details.

 

Regards,

Jimmy Tao

kevinkangdinata
New Member
‎09-22-2020 08:55 PM

Hi Jimmy,

 

Could query timeout issue causes this problem and this error message? If im not mistaken the mysql setting has query timeout of 10 minutes. 

 

In the desktop I disable the enable parallel loading of tables option. So it query one by one, but in the service I dont think it is able to do that, so the query may take longer.

 

Thank you

Idea Statuses