OneLake SharePoint and OneDrive shortcuts now support workspace and service principal identities (Preview)
OneDrive and SharePoint (ODSP) shortcuts let you use your existing Microsoft 365 files directly in OneLake without copying or moving them. This gives analytics, BI, and AI workloads a unified, governed view of both structured data and documents. This eliminates duplication and silos while enabling powerful scenarios like combining spreadsheets with Lakehouse data, indexing documents for AI, and optionally transforming files into analytics-ready tables that stay in sync.
In our previous blog post, we covered the benefits of using OneDrive and SharePoint Shortcuts and how to get started. Today, we’re sharing an important update that expands how organizations can securely use OneDrive and SharePoint shortcuts at scale.
What’s new and advantages
Workspace Identity (WI) and Service Principal (SPN) authentication type support is available for SharePoint and OneDrive Shortcuts. These authentication types unlock several key advantages:
- Centralized authentication: Eliminates reliance on individual user credentials, reducing disruptions when users leave the organization.
- Improved governance: Authentication is managed through Microsoft Entra ID, enabling consistent oversight and control.
- Higher API limits: WI and SPN authentication support higher limits, helping reduce throttling.
- Cross‑tenant access: Service principals enable access to SharePoint and OneDrive content across tenants.
Real-world examples
Using this feature, customers can accomplish the following:
- A data engineering team eliminates daily credential failures by switching pipelines to service principal–based shortcuts.
- An organization shares critical Excel Spreadsheets and documents stored in SharePoint and OneDrive with other organizations to support analytics, business intelligence, and AI-driven scenarios.
How to get started
- Create a service principal name (SPN) in Microsoft Entra ID. If you use Workspace Identity, then enable Workspace Identity (WI).
- Grant the appropriate SharePoint or OneDrive permissions by following the steps in the Configure workspace identity authentication documentation.
- Create SharePoint or OneLake Shortcut in a Lakehouse using the SPN or WI.
Explore the SharePoint and OneDrive documentation to get started, try OneLake Shortcuts in your Lakehouse, and share your feedback to help shape future enhancements.
