Forum Discussion

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. ...

Anonymous

Not applicable

7 years ago

ushah763,

You would need to change the credential option in Power BI Desktop, then re-publish PBIX file to Power BI Service.

Regards,
Lydia

Helper I

7 years ago

Anonymous

i do not have that option.

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
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
Helper I
7 years ago
Anonymous

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