Forum Discussion
Data Gateway Refresh Fail- No Fail Reason Given
Hi ,
I have managed to resolve the issue.... It was a sceduling clash with our internal server....
Many Thanks
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
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 ZhangHi ,
I have managed to resolve the issue.... It was a sceduling clash with our internal server....
Many Thanks