Power query background refresh while file is closed?

[mn11079]

Does this work while the file is closed by default? And if not, are there any workarounds to enable this? For information, the file is saved in a onedrive folder, the refresh interval is set to 10 minutes, and the file is used as a data source for a Power BI report.

[#2 · Accepted solution]

No, it only works when loaded in Excel I'm afraid. Perhaps this discussion helps? https://powerusers.microsoft.com/t5/Building-Power-Apps/Schedule-Data-Refresh-SharePoint-Excel/td-p/...