
Microsoft spells out how Power Query reads SharePoint folders and lists
Microsoft documents Power Query SharePoint Folder and List connectors for Excel and Power BI. File combine depends on consistent layouts, permissions, and paths. Schema drift and auth breaks remain common refresh failure modes for library-based reports.



















