Forum Discussion
Solved
Power query background refresh while file is closed?
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.
- 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/317569
1 Reply
- 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/317569