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

[Nicolas44]

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 root of SharePoint; it is a subfolder (and this is the problem because I cannot reach this folder with the "New Source / File / SharePoint Folder" function). There is no window allowing me to browse and access subfolders.
Other workaround solutions do not allow sharing:

• Using the synchronized folder link "C:\Users\id#\Dossier1\dossier2" (from Windows Explorer) only works on my PC. But this is an Excel file (and thus a Power Query) shared with others.
• Using the link provided in SharePoint "https://sharepoint.com/sites/Folder1/Folder2/...." Power Query does not recognize it as a folder.

In short, I feel like I’ve tried everything, but I still can't get my query to work!
It only works on my PC with the link "C:\Users\id#\Dossier1\dossier2," but not on my colleagues' PCs with whom I share this Excel file (containing these Power Query queries).

Is there a solution? One that would be very helpful for me and many other users.

Thanks in advance.

Message original en français :

Bonjour,

J'ai un problème pour utiliser un lien vers un dossier SharePoint dans Power Query.

Les recherches et solutions proposées sur ce forum n'ont pas résolues le problème.

Le dossier que je veux atteindre n'est pas la racine du Share Point, c'est un sous-dossier (et c'est ce qui pose problème, car je n'arrive pas à atteindre ce dossier avec la fonction "Nouvelle Source / Fichier / Dossier SharePoint". Impossible de cibler un autre dossier que la racine du SharePoint. Il n'y a pas de fenêtre permettant d'explorer et d'atteindre les sous-dossiers.

Les autres solutions palliatives ne permettent pas d'utiliser en partage :

1. Avec le lien du dossier synchronisé "C:\Users\id#\Dossier1\dossier2" (depuis l'Explorateur Windows), ça ne fonctionne que sur mon PC. Or c'est un fichier Excel (et donc une requête Power Query) partagée.
2. Avec le lien proposé dans SharePoint "https://sharepoint.com/sites/Dossier1/dossier2/etc.", Power Query ne le reconnait pas comme un dossier.

Bref, j'ai l'impression d'avoir tout essayé et je n'arrive toujours pas à faire fonctionner ma requête !

Ca fonctionne uniquement sur mon PC avec le lien "C:\Users\id#\Dossier1\dossier2" mais pas sur le PC de mes collègues avec qui je partage ce fichier Excel (contenant ces requêtes Power Query).

Existe-t-il une solution ? qui me rendrait bien service, ainsi qu'à de nombreux autres utilisateurs.

Merci d'avance

[tayloramy · Accepted solution]

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 · Accepted solution]

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.

[cengizhanarslan · Accepted solution]

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]

Thank you 🙂

[tayloramy · Accepted solution]

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. 

[Nicolas44 · Accepted solution]

Thank You, it works 🙂