Forum Discussion

thomaskelly's avatar
thomaskelly
Helper I
9 years ago
Solved

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 take...
Need Help
  • thomaskelly's avatar
    thomaskelly
    9 years ago

    Hi ,

     

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

     

    Many Thanks

thomaskelly's avatar
thomaskelly
Helper I
9 years ago

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's avatar
Anonymous
Not applicable
9 years ago

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's avatar
    thomaskelly
    Helper I
    9 years ago

    Hi ,

     

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

     

    Many Thanks