Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Minakshi
Resolver I
Resolver I

Failure details: The last refresh attempt failed because of an internal service error.

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

1 ACCEPTED 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.

View solution in original post

4 REPLIES 4
v-yangliu-msft
Community Support
Community Support

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/The-last-refresh-attempt-failed-because-of-an-internal-serv...

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.

lbendlin
Super User
Super User

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.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors