Forum Discussion
Scheduled refresh has been disabled.
I had created a report which is pulling data from two sources. (1) an excel file in sharepoint and (2) the opportunity object in Salesforce.com. I am logging into the latter with my credentials. ...
Anonymous
I used the "Excel" connector in the "Get Data" menu.
ushah763,
You are combining on-premises data source(Excel) and online data source(salesforce) in a single dataset, in this case, gateway is required.
"I had to install a personal gateway for the scheduled refresh to work. Now everytime my computer is asleep or down, the refresh fails.
"
However , based on your previous reply, your computer could be asleep or down. Then it is an expected behavior that the schedule refresh is not working for the dataset, as stated in this article, you shouldn't install a gateway on a computer, such a laptop, that may be turned off, asleep, or not connected to the Internet because the gateway can't run under any of those circumstances.
Regards,
Lydia