Data Gateway Refresh Fail- No Fail Reason Given

[thomaskelly]

Hello,

I am trying to refresh a worksheet in the power BI service . The worksheet is connected to a sql databse and one excel document. The worksheet refreshes fine on Power Bi desktop and takes around 40mins to do so. I have a data gateway running on the power bi service which is showing as online and the data source credentials are good.

The last attempt at refresh showed no fail reason , but i have gone through numerous reasons over the past week only for one failure reason to lead to another.

The local PC that stores the pbix file is 64bit with an intel i3 3.3ghz 2 core, 4 logical processors. with 4gb of physical ram and 10gb of virtual ram.

Below are the latest details of my refresh failure, the refresh was started at 8.00pm uk time.

Last refresh failed: Thu Jan 05 2017 22:01:46 GMT+0000 (GMT Standard Time)

Cluster URI:	WABI-NORTH-EUROPE-redirect.analysis.windows.net
Activity ID:	52b3bc62-4cd4-4646-9359-
Request ID:	80303634-2fb1-45cb-bff0-
Time:	2017-01-05 22:01:46Z

[thomaskelly]

Hello,

I am trying to refresh a worksheet in the power BI service . The worksheet is connected to a sql databse and one excel document. The worksheet refreshes fine on Power Bi desktop and takes around 40mins to do so. I have a data gateway running on the power bi service which is showing as online and the data source credentials are good.

The last attempt at refresh showed no fail reason , but i have gone through numerous reasons over the past week only for one failure reason to lead to another.

The local PC that stores the pbix file is 64bit with an intel i3 3.3ghz 2 core, 4 logical processors. with 4gb of physical ram and 10gb of virtual ram.

Below are the latest details of my refresh failure, the refresh was started at 8.00pm uk time.

Last refresh failed: Thu Jan 05 2017 22:01:46 GMT+0000 (GMT Standard Time)

Cluster URI:	WABI-NORTH-EUROPE-redirect.analysis.windows.net
Activity ID:	52b3bc62-4cd4-4646-9359-
Request ID:	80303634-2fb1-45cb-bff0-
Time:	2017-01-05 22:01:46Z

[Anonymous]

Hi @thomaskelly,

Do you store the Excel file in local disk or in online service such as OneDrive for Business?

In addition, do you have external data sources in the Excel file? And have you tried to delete your dataset and reconnected to it via “Get Data->Files” entry in Power BI Service?

Thanks,
Lydia Zhang

[thomaskelly]

Hi ,

The excel file is on the desktop along with the pbix file. I managed to setup a gateway on Friday that refreshed twice and once as a sceduled refresh then I got a new message stating that all of the schduled refreshes had failed over the weekend,

This was a microsoft SQl: timeout expired error.  and a microsoft data mashup error. So one step forward and three back at the moment.

Kind Regards

Thomas

[Anonymous]

Hi @thomaskelly,

I know that you connect to Excel file in Power BI Desktop. We need to know where is the Excel file stored, local disk or onedrive? And how do you upload PBIX file to Service? Is there a large amount of data in the Power BI Desktop?

Could you post a screenshot about the error message in your refresh history?

Thanks,
Lydia Zhang

[thomaskelly · Accepted solution]

Hi ,

I have managed to resolve the issue.... It was a sceduling clash with our internal server....

Many Thanks