Power BI Exchange

Expand all | Collapse all

Loading files from Sharepoint Folders

  • 1.  Loading files from Sharepoint Folders

    Posted Apr 13, 2018 02:55 PM
    I am trying to access files from our SharePoint site at work using the Sharepoint Folder connector.  I have been able to connect to the root site and see a list of files. The issue I am having is that not all of the subfolders and files are showing up.  I haven't been able to figure out why some sub-folders/files show up and others don't.   If anyone has any information or thoughts on why this could be happening please let me know.



  • 2.  RE: Loading files from Sharepoint Folders

    Posted Apr 16, 2018 06:50 AM
    Hi Jud,

    While I'm afraid I can't answer your underlying question, perhaps I have a workaround.  When I've been connecting to Sharepoint files (Excel, CSV, etc.), I've simply been using a basic web connector and inputting the URL for the file:

    https://MYSITE.sharepoint.com/PATH.xlsx or https://MYSITE.sharepoint.com/PATH.csv

    This has worked like a charm for me.

    I got this advice from a help site, but unfortunately, I can't for the life of me find the original post that guided me down this path.

    Hope this helps.



  • 3.  RE: Loading files from Sharepoint Folders

    Posted Apr 16, 2018 09:00 AM
    Need more info. Is this SP Online, or on-prem? I agree with JJ that connecting via "web" works well.

    Garth Woods
    VP Information Technology
    Marine Ingredients
    Mount Bethel PA