Forum Discussion

admiralman's avatar
admiralman
Advocate II
9 years ago
Solved

Sharepoint Folder

I would like to target a folder within a Sharepoint Online library similar to the "connect to folder" functionality that exists on the local client. Can anyone tell me if this is possible? I have see...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    9 years ago

    Hi admiralman,

     

    Based on my test, we have to list all available folders, then select those we need from the list. As mentioned in above link:

     

    Now that we’re in, 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.

     

    If we direct to a specific folder in URL (https://microsoft.sharepoint.com/xxxx/xxxx/Shared%20Documents/Power%20BI), it will fail to connect and prompt below error.

     

     

    Regards,
    Yuliana Gu

Anonymous's avatar
Anonymous
Not applicable
6 years ago

And what to do when you have two folders, each containing one file = two files total, but Get Data only sees one of the files?

 

We do not have folder level permissions set, version control is off. PBI should see two different paths and one file for each path. It doesn't.

 

Working with SharePoint seems a lot more painful than it should be. 

Alwyn1991's avatar
Alwyn1991
Frequent Visitor
6 years ago

Are you using a file specific URL for the data connector or using the sharepoint site URL

 

i tend to use the latter and navigate to the file, the only other thing i can think of is if they are 2 different files? i.e. xlsx & xls

normally sharepoint folder data connector seems to remove the idea of foldesrs within the document library and i just have huge list of files to select from