SharePoint folder links still break scheduled Power BI and Excel refreshes
Reviewed by Helen Jones
Microsoft’s Power Query and Power BI refresh documentation still spells out how SharePoint folder connectors fail in real schedules. Authentication, file identity, gateway setup, and sensitivity labels all sit in the failure path when files move, rename, or change permissions. Report packs that pull Excel or CSV collections from SharePoint stay tied to stable paths, a working gateway where required, and credentials the service account can actually use. Online and on-premises gateway behavior is not the same, and fine-grained SharePoint permissions can block the account that runs refresh even when a person can open the files by hand. That pattern remains common for departmental reporting. The docs are not announcing a fix. They are restating the operational limits teams hit every month.
For years, the easy departmental pattern was a SharePoint folder of workbooks or exports, a Power Query folder connector, and a hope that scheduled refresh would behave like a desktop refresh. Desktop success hid the real contract: the path, the file names, the gateway, and the service identity all had to stay frozen for the pack to keep working without someone babysitting it. What the documentation keeps making clear is that nothing about that contract has gotten softer. Unattended refresh is still a different product surface from interactive open-and-load. If your trusted monthly numbers still start as a SharePoint folder of files, the weak point is not a missing visual. It is ownership of path stability, gateway configuration, and the account that is allowed to read those files when nobody is watching.
Analysis
Treat SharePoint folder connectors on any pack that must refresh on a schedule as a known trap, not a finished architecture. Before the next monthly run, list every critical workbook or dataset that still points at a SharePoint folder, freeze naming and folder layout, and write down which gateway and which service identity own the refresh so a rename or permission tweak does not become a silent outage.
Source note
Pulse published by Collab365 Spaces, reviewed by Helen Jones on . Cite as "SharePoint folder links still break scheduled Power BI and Excel refreshes", Collab365 Spaces. 3 sources referenced.