Forum Discussion

CraigSchulz's avatar
CraigSchulz
Icon for Helper II rankHelper II
8 years ago
Solved

Get Data "From Folder" from Sharepoint Folder

Has anyone had any luck getting data using the from "Sharepoint Folder" option? When I try to point to the folder it tells me I need to put the URL for the Sharepoint root in the box. When I point to...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi CraigSchulz

    After researching, i haven't found any way to connect directly to Sharepoint Folder as you described.

    A well-known way is using "Sharepoint Folder" connector and selecting your desired folder from the displaying list of folders' path.

    Combining Excel Files hosted on a SharePoint folder with Power BI

    After we connect to sharepoint successfully, we’ll be able to see all of the files from all of the folders that we have access to in that specific site.

    This might be a pretty long list, so let’s do some filtering on the “Folder Path” column and select the folder where your data is being stored so you only get the files from it.

     

    Best Regards

    Maggie

feelie75's avatar
feelie75
Icon for Helper I rankHelper I
2 years ago

But what if you don't have access to the ROOT of the site, but only have access to the Documents/ folder? Power BI requires a root URL, but I don't have access to that. How can you link directly to the folder or excel file???