Microsoft Fabric: Cloud File Shortcut

Key insights

• Shortcut: The video shows how Fabric creates a shortcut from a Lakehouse to OneDrive or SharePoint so files stay in place while Fabric references them like regular OneLake files.
  
• OneLake integration: Files from OneDrive and SharePoint appear inside OneLake alongside structured and unstructured data, letting teams run analytics and AI without copying data.
  
• Real-time updates: Because files remain in their original storage, edits on OneDrive or SharePoint appear immediately in Fabric reports, notebooks, and AI workloads.
  
• Governance: Access follows Fabric and OneLake security and admin policies, keeping enterprise controls consistent and simplifying document management.
  
• How to create: In a Fabric workspace open a lakehouse, right-click a folder, choose "New shortcut", select OneDrive or SharePoint, sign in with your work account, and pick the folders to reference.
  
• Preview and scope: The feature is in preview and uses organizational authentication; admins can control Power BI viewing and the shortcut reduces ETL needs while enabling AI transforms and broader integrations.
  

Introduction

In a recent YouTube video, Reza Rad (RADACAD) [MVP] demonstrates a practical new capability in Microsoft Fabric that simplifies access to files stored in OneDrive and SharePoint. The video explains how users can create a shortcut from a Fabric lakehouse to folders in those Microsoft 365 services, enabling direct use of documents without copying them into OneLake. Consequently, teams can include Word, Excel, PowerPoint, and PDF files in analytics and AI workflows while the originals remain in their native storage locations.

How the Shortcut Works

The process is straightforward and the video walks viewers through authenticated access and selection of target folders. First, you open a lakehouse in Fabric, right-click a folder and choose “New shortcut,” then select a OneDrive or SharePoint folder and authenticate with your organizational account. After that, the referenced files appear in OneLake and become available for reports, notebooks, AI agents, and data transforms without duplicating content.

Because the files stay in their original locations, updates made by collaborators show up immediately inside Fabric workflows. This live reference model reduces the need for periodic copying or scheduled ETL jobs to refresh documents. However, it requires correct access permissions and an authenticated organizational account for each user who needs to interact with the shortcut.

Benefits and Practical Uses

One clear advantage is a more unified view of enterprise data: documents from OneDrive and SharePoint show up alongside structured data in OneLake, which helps teams build richer analytics and AI scenarios. For example, BI developers can present contextual documents next to data tables, while AI models can index unstructured PDFs or contracts for knowledge-base queries and embeddings. As a result, organizations can bridge productivity content and analytics without heavy data movement.

Moreover, governance gets simpler because access to those files follows the policies set by Fabric and OneLake, ensuring consistent enterprise controls. Real-time updates enable immediate insights when collaborators edit source documents, which benefits finance, sales, and operations teams that rely on up-to-date files. In short, the feature streamlines several common workflows by reducing manual file transfers and by enabling live document integration.

Tradeoffs and Technical Challenges

Although the shortcut approach reduces duplication, it introduces tradeoffs around performance and reliability because queries now depend on live access to external storage locations. In practice, latency can vary based on network conditions and the responsiveness of OneDrive or SharePoint, which may affect interactive reports or large-scale AI transforms. Therefore, teams must weigh the benefit of real-time access against potential performance variability and design for caching or batched operations when needed.

Security and permission management also present challenges since users need appropriate rights both in Fabric and in the source Microsoft 365 locations. Administrators must coordinate policies to avoid access gaps or unintended exposure. Additionally, indexing and extracting value from unstructured documents requires extra processing and governance work, so organizations should plan for metadata, search optimization, and potential compliance checks before relying on shortcuts for critical workflows.

Governance, Adoption, and Recommendations

The feature is currently available in preview and uses organizational account authentication only, so early adopters should test in controlled environments. Administrators can enable controls to view and share Power BI files stored in OneDrive and SharePoint within Fabric, which helps maintain central governance while enabling flexible access. Consequently, pilot projects that focus on specific teams or use cases—such as sales decks or finance trackers—are a sensible first step before broad rollout.

To adopt this feature successfully, balance immediate convenience with long-term operational needs. For example, use live shortcuts for collaboration-heavy documents and preserve copied data when you need predictable performance or historical snapshots. Ultimately, the approach promises to reduce ETL complexity and improve productivity, but organizations must plan for permission management, performance tradeoffs, and indexing needs to get the most value.

Conclusion

Reza Rad’s video highlights a notable evolution in how Microsoft Fabric integrates everyday productivity content into analytics and AI workflows by referencing files in OneDrive and SharePoint. While the shortcut model offers unified views, real-time updates, and simpler governance, it also raises practical concerns about latency, access control, and document indexing that teams should address. Therefore, measured pilots and close collaboration between IT, governance, and business owners will help organizations balance benefits and risks as they adopt this capability.

Keywords

Microsoft Fabric OneDrive shortcut, Microsoft Fabric SharePoint shortcut, Add OneDrive shortcut Microsoft Fabric, Add SharePoint shortcut Microsoft Fabric, Access OneDrive from Microsoft Fabric, Access SharePoint from Microsoft Fabric, OneDrive SharePoint integration Microsoft Fabric, Create shortcut to OneDrive and SharePoint in Microsoft Fabric