Forum Discussion

mkjit256's avatar
mkjit256
Icon for Helper IV rankHelper IV
4 days ago

SharePoint Shortcut showing no Content

Hello I am trying to set a shortcut in Lakehouse (tried both the create table shortcut, and create shortcut from files section) to a SharePoint folder, I can see the site, and also the connection authenticate correctly, however when I click next I am only present by one folder, which is the Shared Document folder that show no content though i am sure that there is files and folders as viewed in browser.

I am using the patter of https://tenant.sharepoint.com/sites/sitename

 

8 Replies

  • Hey mkjit256​ ,

    this is usually one of these:

    1. Delegated vs. app permissions – If your SharePoint connection is using an app-only/service principal auth method rather than your own delegated login, it can browse the site and see the folder structure but fail to enumerate files if permissions weren't explicitly granted at the library level, not just the site level.
    2. Broken/synced files showing as empty – If the "Shared Documents" folder has files synced via OneDrive client or has some in a "pending" state, the shortcut browser sometimes shows nothing even though the web UI displays content, this is a caching mismatch between SharePoint's Graph API response and what you see in browser.
    3. URL trailing slash or casing – Since you're using the sites/sitename pattern, double check there's no trailing slash and the site name casing matches exactly. Fabric's shortcut connector can silently fail to traverse if there's a mismatch.
    4. Folder-level unique permissions – If someone broke inheritance on subfolders inside Shared Documents (common in larger orgs), the connector account may see the parent folder exists but can't read into it, this shows as "No Content" rather than an access-denied error, which is misleading.

    Fastest way to isolate it: try creating the shortcut against a brand new, simple test folder with no nested subfolders or broken permissions. If that works, it confirms it's a permissions/inheritance issue on your actual folder, not a connector bug.

  • v-aatheeque's avatar
    v-aatheeque
    Icon for Community Support rankCommunity Support

    Hi mkjit256​ 

    Have you had a chance to look through the responses shared earlier? If anything is still unclear, we’ll be happy to provide additional support.

  • Hi mkjit256​ 

    What happens if when you create the new shortcut on the connection page, create a new connection to the Sharepoint site to see if that resolves your issue?

  • seems like my url is not a site, the whole pattern where my files exist is:

    https://companyname.sharepoint.com/sites/BIA/Ops/Forms/AllItems.aspx?id=%2Fsites%2FBIA%2FOps%2FPowerBI%20Data%2FOutput&viewid=a***7%2Ge515%2D4661%2D8581%2D3aa9d5c5f7e1&newTargetListUrl=%2Fsites%2FBIA%2FOps&viewpath=%2Fsites%2FBIA%2FOps%2FForms%2FAllItems%2Easpx

    from my research it seems like BIA is the Sharepoint Site, Operations is the Document Library and PowerBI Data/Output is the folder.

    what i am providing in the connection is https://companyname.sharepoint.com/sites/BIA but still having an empty folder. 

    is it supported to create a shortcut using such url pattern? if not where do you suggest that i put my files into?


    • ShivekMaharaj's avatar
      ShivekMaharaj
      Icon for Solution Sage rankSolution Sage

      Hi mkjit256​,

      That extra URL helps quite a lot.

      I would not move the files into Shared Documents yet. Microsoft's current OneDrive/SharePoint shortcut documentation does not state that shortcuts are limited to the default Documents library. In fact, Microsoft recommends creating the shortcut at the most specific folder level rather than at the document-library root.

      From the URL you posted, it looks like:

      • BIA is the SharePoint site
      • Operations is the display name of the document library
      • Ops is probably the library's internal URL name
      • PowerBI Data/Output is the folder you actually want


      So the target path appears to be something like:

      /sites/BIA/Ops/PowerBI Data/Output

      The fact that the Fabric picker only exposes Shared Documents therefore looks more like a library-enumeration issue than proof that your custom library is unsupported.

      One useful isolation test would be to create a fresh connection against the exact site URL:

      https://companyname.sharepoint.com/sites/BIA

      using the same organizational account that can browse the Ops library in SharePoint, then check whether Ops appears in the shortcut browser.

      If it still only shows Shared Documents, I would capture that as the repro.

      There is also a OneLake Shortcuts REST API where a SharePoint shortcut is represented by a location and subpath. That may be worth testing as a workaround because the API lets you specify the SharePoint subpath directly rather than relying on the folder picker.

      I would use the library's URL/internal name (Ops) rather than its display name (Operations) when testing the path.

      Also confirm that BIA is a normal SharePoint site rather than a subsite or hub site, because Microsoft currently lists SharePoint subsites and hub sites as unsupported for OneLake shortcuts.

      AI-assisted drafting: AI was used to help structure and phrase this response. I reviewed and validated the technical content before posting.

    • mkjit256's avatar
      mkjit256
      Icon for Helper IV rankHelper IV

      Hi v-aatheeque​  you might have missed my comment yesterday. Sorry seems that i didn't reply to you but placed my comment as a general reply.

  • Kagiyama_yutaka's avatar
    Kagiyama_yutaka
    Icon for Continued Contributor rankContinued Contributor

    Fabric only lists stuff from the site’s standard Documents library, and it works only when you’re signed in with the same account that can see it in the browser.

    When Shared Documents looks empty, just open that library with that account, check the files really live in Documents, then make the shortcut again from Files → New shortcut → OneDrive or SharePoint folder.

  • v-aatheeque's avatar
    v-aatheeque
    Icon for Community Support rankCommunity Support

    Hi mkjit256​ 

    The URL format https://tenant.sharepoint.com/sites/sitename is valid for a SharePoint site. Since the connection is authenticating successfully but the Shared Documents library appears empty in the Fabric shortcut picker, this looks more like an issue with how the SharePoint library/folder is being enumerated rather than an authentication failure.

    Please verify the below following:

    • The URL is the actual site URL, not a subsite or hub site.
    • The account used for the Fabric connection has access to the Shared Documents/Documents library and the target folder.
    • The files are located in the standard document library and not in an unsupported SharePoint location.
    • If possible, try creating the shortcut from Files → New shortcut → OneDrive or SharePoint Folder and expand Shared Documents to see whether the folders appear.

    Useful links: Create a OneDrive or SharePoint shortcut - Microsoft Fabric | Microsoft Learn

    https://community.fabric.microsoft.com/discussions/ac_generaldiscussion/lakehouse-shortcut-sharepoint-files-disappearing/5143364/replies/5148338