Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Kindly help me with this error.
Failure details: The last refresh attempt failed because of an internal service error. This is usually a transient issue. If you try again later and still see this message, contact support.
{"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":"<pi>MySQL: Fatal error encountered during data read.</pi>"}},{"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":" DB}},{"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: Table1.
My other reports are getting refreshed which are uding a different source, which means I don't have any issue with gateway.
Thanks
Solved! Go to Solution.
Hi @v-yangliu-msft
Many thanks for your suggestions. I made it fixed by changing merge query table refrenced instead of (independent) fetching back the dataset table. It seems, it was an issue with mashup containers. But now my both dashboards are getting refreshed.
Hi @Minakshi ,
You can try the following operations:
The first:
Download the latest version of Power bi Desktop and republish to Power bi services.
The second:
remove the broken reports from the Online service and re-add them.
1 - Open the report(s) in PBI Desktop and clear the cache (file...options and settings... options).
2 - Refresh the data in the desktop and save.
3 - Open PBI Online and remove the associated dataset(s). Note - you'll need to remove the reports from any content packs before you can remove the reports and data from the online service. Also you might want to make a note of the (failed) refresh schedule you had before doing this so you can recreate it exactly.
4 - Hop back to PBI Desktop and publish the report from PBI Desktop to Online.
5 - Hop back to PBI Online and set the refresh schedule back up.
6 - Add the reports back into any apps or content packs.
This is a link to related content, I hope it will help you:
https://community.powerbi.com/t5/Service/Scheduled-Refresh-Failed/td-p/770141
https://community.powerbi.com/t5/Service/Refresh-Failed-Internal-Service-Error/td-p/381780
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @v-yangliu-msft
Many thanks for your suggestions. I made it fixed by changing merge query table refrenced instead of (independent) fetching back the dataset table. It seems, it was an issue with mashup containers. But now my both dashboards are getting refreshed.
How many data sources in the dataset? What type of data sources? Any of the data source queries using merge steps?
only 1 data source. MySql database. It was working perfectly fine but suddenly started showing this error. On my local machine (power bi desktop) it is getting updated without any issue.
yes, I have merge steps with same data source.