Error while refreshing the data : data source error

[KacificPDI]

Hello everyone,

I tried to refresh my data on my Power BI report and got an error message stating the following:

"""

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":"db1bmorgn01.cha0ylhxpqne.ap-southeast-1.rds.amazonaws.com;morrigan_esp_data"}},{"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}}} Table: Re-activations_in_last_48_hours.
Cluster URI: WABI-SOUTH-EAST-ASIA-B-PRIMARY-redirect.analysis.windows.net
Activity ID: 46812eaa-59d7-4f54-9f2b-bb261823700c
Request ID: ff4d3081-fe14-0283-faf5-5861529bd37c
Time: 2023-08-03 07:47:10Z

"""

Could you please help me understand what the erro is exactly and above all how to fix it ?

Many thanks in advance

[v-rongtiep-msft · Accepted solution]

Hi @KacificPDI ,

The error message you received indicates that there was an issue with the data source when you tried to refresh your data on your Power BI report. This could be due to a variety of reasons such as network connectivity issues, incorrect credentials, or an issue with the data source itself.

To troubleshoot this issue, I would recommend the following steps:

1. Check your network connectivity to ensure that your Power BI report can access the MySQL data source.
2. Verify that the credentials you are using to access the data source are correct and have the necessary permissions.
3. Check the MySQL data source itself to ensure that it is functioning properly and that there are no issues with the data.

If it does not help, please provide more details.

Best Regards
Community Support Team _ Rongtie

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