Power Query - Browse SharePoint in Modern Get Data
Data Factory · Public preview · Planned
Description
We are enhancing Power Query's Modern Get Data experience with SharePoint browsing, enabling customers to discover and select files and folders directly from their SharePoint sites instead of manually finding and copying URLs.
This improvement makes it easier for business users to connect to the shared data their teams already use. By bringing SharePoint browsing into Get Data, customers can spend less time locating the correct file links and more time preparing data for analysis.Key benefits and scenarios:
- Browse rather than copy links: Navigate SharePoint sites and folders to select the content needed for data preparation.
- Connect to everyday business files: Bring shared files into Power Query through a guided selection experience.
- Move smoothly into data preparation: Preview the selected data and begin transforming it within the familiar Power Query authoring flow.
- Keep connection flexibility: Use browsing for simpler discovery while retaining manual URL entry when preferred.
This release simplifies the path from shared content in SharePoint to data preparation in Power Query.
Change History
-
2026-10-29
Roadmap Item Added
Workload: Data Factory