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

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Even am facing issues while using SharePoint Folder option. I am trying to access a folder in OneDrive , but I am not able to actually get the correct URL to input . Can some one help please ?

 

When I click on Get Data -> Sharepoint Folder 

 

Input URL as https://[companyname]-my.sharepoint.com/ -> this works , but doesnt list the folders that I am looking for.

 

This is the actual URL of my One Drive folder which I need to access through Power BI.

https://[companyname]-my.sharepoint.com/personal/[username]_[company_name]_com/Documents/[MyFolderName] . Can you tell me how to derive the URL that I need to input in Power BI Share point folder option ?

  • dpombal's avatar
    dpombal
    Icon for Post Partisan rankPost Partisan
    7 years ago

    I am having same issue how to connect sharepoint folder ?