Forum Discussion

Nicolas44's avatar
Nicolas44
Regular Visitor
7 months ago
Solved

Link to a SharePoint folder in a Power Query / French : Lien vers un dossier SharePoint dans requête

Hello, I am having trouble using a link to a SharePoint folder in Power Query. The searches and solutions proposed on this forum have not resolved the issue. The folder I want to access is not the...
Need Help
  • tayloramy's avatar
    tayloramy
    7 months ago

    Hi Nicolas44, 

     

    The SharePoint folder connector is the intended way to do this. 

    THere is no popup to select a folder, but you are able to filter on path. 

     

     

    My recommendation is to use the SharePoint Folder connector, and then filter on path to get only the documents in the folder you want. 

     

  • cengizhanarslan's avatar
    cengizhanarslan
    7 months ago
    1. Data → Get Data → SharePoint Folder
    2. Enter the site root URL (not the folder URL), e.g.
      https://yourtenant.sharepoint.com/sites/YourSite
    3. In the table returned, filter the Folder Path column to your subfolder, for example it should contain something like:
      .../Shared Documents/Folder1/Folder2/
    4. Then filter Extension if needed and combine files.
  • Nicolas44's avatar
    Nicolas44
    7 months ago

    Thank You, it works 🙂

cengizhanarslan's avatar
cengizhanarslan
Icon for Super User rankSuper User
7 months ago
  1. Data → Get Data → SharePoint Folder
  2. Enter the site root URL (not the folder URL), e.g.
    https://yourtenant.sharepoint.com/sites/YourSite
  3. In the table returned, filter the Folder Path column to your subfolder, for example it should contain something like:
    .../Shared Documents/Folder1/Folder2/
  4. Then filter Extension if needed and combine files.
  • Nicolas44's avatar
    Nicolas44
    Regular Visitor
    7 months ago

    Thank you 🙂