Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Scheduled Refresh missing for Excel Workbook

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. 

 

Need Help

1 Reply

  • Tutu_in_YYC's avatar
    Tutu_in_YYC
    Super User
    4 years ago

    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.