Forum Discussion

ushah763's avatar
ushah763
Helper I
7 years ago

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

ushah763,

What connector do you use in Power BI Desktop to connect to the Excel file? It seems that you are connecting to Excel file which is stored in a network path.

Regards,
Lydia

ushah763's avatar
ushah763
Helper I
7 years ago

Anonymous

 

I used the "Excel" connector in the "Get Data" menu.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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