Forum Discussion
Scheduled refresh has been disabled.
Anonymous
I do not see that option when looking at the data source connections from the service.
How, where do I access that to change it? on the desktop or service? and where?
When I go to File > Options and Settings > Data Source Settings
in Power BI Desktop, this is all i see when i select "global permissions"
So where do I go to change the data source credentials?
ushah763,
You would need to change the credential option in Power BI Desktop, then re-publish PBIX file to Power BI Service.
Regards,
Lydia
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,
LydiaAnonymous
i do not have that option.
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,
LydiaAnonymous
I used the "Excel" connector in the "Get Data" menu.