Power query auto refresh

Question

I set up my file to auto-refresh, and I followed the instructions I found on the web. However, it does not refresh in the background, and I have now read another post that says the file must be open for it to auto-refresh. However, in Auto Refresh it says that you don't have to open the file, so what is correct?

sergeibaklan · Answer

Botty1963&nbsp;
File is to be opened. Workarounds are with using of PowerShell, Power BI services, etc
How to auto-refresh Power Query query, without opening the Excel file, when said file is on sharepoint/Teams? : r/excel (reddit.com)
vba - Is it possible to schedule the data refresh of a power query in excel to refresh data at 2 specific times every day? - Stack Overflow
etc

botty1963 · Answer

Many thanks Sergei.

Forum Discussion

Power query auto refresh

Share

Resources