SOLVED

Power query background refresh while file is closed?

%3CLINGO-SUB%20id%3D%22lingo-sub-2773106%22%20slang%3D%22en-US%22%3EPower%20query%20background%20refresh%20while%20file%20is%20closed%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2773106%22%20slang%3D%22en-US%22%3E%3CP%3EDoes%20this%20work%20while%20the%20file%20is%20closed%20by%20default%3F%20And%20if%20not%2C%20are%20there%20any%20workarounds%20to%20enable%20this%3F%20For%20information%2C%20the%20file%20is%20saved%20in%20a%20onedrive%20folder%2C%20the%20refresh%20interval%20is%20set%20to%2010%20minutes%2C%20and%20the%20file%20is%20used%20as%20a%20data%20source%20for%20a%20Power%20BI%20report.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2773106%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20BI%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2774612%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20query%20background%20refresh%20while%20file%20is%20closed%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2774612%22%20slang%3D%22en-US%22%3ENo%2C%20it%20only%20works%20when%20loaded%20in%20Excel%20I'm%20afraid.%20Perhaps%20this%20discussion%20helps%3F%20%3CA%20href%3D%22https%3A%2F%2Fpowerusers.microsoft.com%2Ft5%2FBuilding-Power-Apps%2FSchedule-Data-Refresh-SharePoint-Excel%2Ftd-p%2F317569%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fpowerusers.microsoft.com%2Ft5%2FBuilding-Power-Apps%2FSchedule-Data-Refresh-SharePoint-Excel%2Ftd-p%2F317569%3C%2FA%3E%3C%2FLINGO-BODY%3E
New Contributor

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.

1 Reply
best response confirmed by mn11079 (New Contributor)
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/...