Repeated refresh failures - Internal Service Error

[dporter]

Greetings,

Approx 1 day ago I started getting refresh failures on the Power BI Cloud service for two seperate datasets. No recent changes to either of the Power BI models.

Source data is in Microsoft CRM Online. With no prior issues. All error messages are stating : Internal Service Error

Dataset #1 : 

Last refresh failed: Thu Jun 15 2017 07:33:02 GMT-0700 (Pacific Daylight Time)
The last refresh attempt failed because of an internal service error.Hide details

Cluster URI:	WABI-WEST-US-redirect.analysis.windows.net
Activity ID:	de573da6-4a5f-47e6-85a2-8cb0abd48918
Request ID:	70cec2b1-fe37-ea64-7452-37b0f36fff5c
Time:	2017-06-15 14:33:02Z

Dataset #2

Scheduled	6/15/2017, 6:01:08 AM	6/15/2017, 6:29:42 AM	Failed	The last refresh attempt failed because of an internal service error.
Cluster URI: WABI-WEST-US-redirect.analysis.windows.net Activity ID: cb52f4c0-eb84-4d6d-a94a-3735587dc481 Request ID: 1a3ae57b-9be1-453d-ba43-5c718d29d14b Time: 2017-06-15 13:29:42Z

[v-yuezhe-msft · Accepted solution]

@dporter,

There are some proposals for you troubleshooting this issue.

1. Use latest version of Power BI Desktop(2.47.4766.542) to create reports for your data source.
2. Use fiddler to monitor what happened during the refresh process.


Regards,
Lydia Zhang

[v-yuezhe-msft · Accepted solution]

@dporter,

There are some proposals for you troubleshooting this issue.

1. Use latest version of Power BI Desktop(2.47.4766.542) to create reports for your data source.
2. Use fiddler to monitor what happened during the refresh process.


Regards,
Lydia Zhang

[vaibhav_osc]

Yes, republishing the report solves this issue. However, it is not sustainable to keep republishing reports everytime a new version comes out.

From what I have noticed, with the Internal Service Error, the report does get refreshed but it does not reflect on to the dashboard. The obvious reason seems to be it can't refresh the tiles automatically in the refresh process. Manual refresh tiles does refresh the dashboards in this scenario. (Although you would still get the Internal Service Error the next time you refresh)

[dporter · Accepted solution]

Thank you ...  using the latest version of Power BI and re-publishing to the Power BI Service resolved this issue.