Forum Discussion

mkjit256's avatar
mkjit256
Icon for Advocate II rankAdvocate II
1 day 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

 

4 Replies

  • 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

     

  • 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.

  • 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?


  • 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?