refresh a excel power query at a particular time of day

Brass Contributor

Hi,

 

i am sure i read somewhere that this could be done and i'm trying to implement it but cannot find any help online that relates to excel, its all done in power bi that i dont use.

 

basically, i want to refresh one of my power queries ( that gets data from the web ), at 10pm each night.

 

is this possible to do ???

 

many thanks for your help, steve reeves

2 Replies
also. workbook willl be open.

although i would also be interested if this can be done without the workbook open? doubt thats easy though ( or even poss), thanks

@stever78 

To my knowledge nope, that doesn't work such way. Former time there were third party utilities which run at scheduled time as Windows task; open Excel file, refresh it and close. Perhaps they are still exists, not sure.

 

Other ways are related to SharePoint (on-premises solution) or Power BI service where data model related to published Excel file could be refreshed without opening it, but you don't use it.