Dataset refresh failures

[jderekc]

Hi all!

I'm new here.  I am having an issue in PowerBI where some of my datasets refuse to update (in fact, most of them).  This is the error I keep getting after a scheduled or on-demand refresh of the dataset:

Last refresh failed: Mon May 29 2017 12:43:43 GMT-0500 (Central Daylight Time)

Cluster URI:	WABI-US-NORTH-CENTRAL-redirect.analysis.windows.net
Activity ID:	c41a4b0e-bbe7-6483-1ac8-5c8babc94e3c
Request ID:	6cdd1e40-02b5-0914-1b8c-b42d475eba9b
Time:	2017-05-29 17:43:43Z

Does anyone have advice on how to proceed with this?  It doesn't seem to give particularly good error information.  The data gateway (enterprise data gateway, not personal) is listed as online.  Here is a snapshot of the history:

Show	On demand	5/29/2017, 11:34:39 AM	5/29/2017, 12:43:43 PM	Failed
Show	On demand	5/29/2017, 10:34:29 AM	5/29/2017, 10:40:45 AM	Failed
Show	On demand	5/29/2017, 9:44:32 AM	5/29/2017, 10:34:29 AM	Failed
Show	Scheduled	5/29/2017, 8:31:19 AM	5/29/2017, 9:44:31 AM	Failed
	Scheduled	5/28/2017, 10:01:04 PM	5/28/2017, 11:00:31 PM	Completed

I appreciate any insight that can be given regarding this issue.  It is turning out to be relatively high priority and I was not sure how to communicate directly with Microsoft regarding this priority issue for my organization.

Thanks!

Regards,

Derek

[Anonymous]

Encountered this before. Check if there were any changes that got published. For whoever published the report, check if there are any query errors in the query editor. If there are errors to any of the queries, even if the data is not being used in the report, the entire report will fail on refresh.

[jderekc]

Thanks for the feedback, fmx.  My reports and the queries behind them are not generating any errors.  It looks like it was the cluster having the issue.

ALL OTHERS:  Is anyone else experiencing slow data refreshes now that it seems the cluster issue has been resolved?  I have some datasets that used to take substantially less time to refresh than they do now.  They are taking more than 30-45 minutes longer to refresh than previously and we have not had a substantial increase in data in the tables being refreshed.

Thanks!

- Derek

[carbonA]

Hi,

I am also new here and I am having the same issue. This has been going on since around 8:00AM central. Our enterprise gateway is online and functioning but the scheduled refreshes are failing. I can manually go in and refresh the data set using the enterprise gateway however at the next scheduled refresh it failes for all of my datasets.

Technical Information:

Activity Id: d6c18e8c-ffea-48fe-9dab-d04af31e081b

Request Id: 834ab7b4-992e-4ab1-b939-9289d8785002

Cluster Name: WABI-US-NORTH-CENTRAL-redirect.analysis.windows.net

Refresh Start Time: 05/30/2017 18:01:23Z

Refresh End Time: 05/30/2017 18:02:11Z

Let me know if there is something I am missing or where to go from here.

Thanks,

Aaron