Forum Discussion
Automate query schedule refresh in Excel while file is not open
Hi, is there a way to automate query refresh in Excel while not opening the file?
Hi HansVogelaar ,
Thank you for your reply. Unfortunately your suggestion does not meet my requirements. I can also trigger my query to automatically refresh when I open the file through the query properties like in the screenshot below.
But what I am looking for is to automate query refresh without even opening the file. I am not sure if it is possible or not.
If you are on business subscription and query source from external data, you may load query to data model (even if you don't use it), upload file on Power BI workspace and schedule refresh here.