Scheduled Refresh missing for Excel Workbook

[Anonymous]

Hi Everyone, 

We have a need to refresh a few Excel Workbooks in the service. They are hosted in sharepoint and the data sources are driven by power query. 

I have managed to add a few workbooks to a Power BI Workspace without any issues, they are refreshing once a day. But one more complicated workbook is missing the scheduled refesh option on the drop down. 

Does anyone have ideas on why? I can open the work book and resfresh it in excel without any issues. 

Also the "Refresh Now" option on the drop down doesn't work. 

Thanks in advance. 

Darren. 

[Tutu_in_YYC]

Hi Darren,

Workbook doesnt have configurable "scheduled refresh". It will automatically be refreshed every hour if changes are detected. The "Refresh now" button should work. If it persists, try removing the workbook and connect to it again in workspace.