cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
thomaskelly
Helper I
Helper I

Data Gateway Refresh Fail- No Fail Reason Given

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

 

 

1 ACCEPTED SOLUTION

Hi ,

 

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

 

Many Thanks

View solution in original post

4 REPLIES 4
v-yuezhe-msft
Microsoft
Microsoft

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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi ,

 

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

 

Many Thanks

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.

Top Solution Authors
Top Kudoed Authors